Re: Connection Collection

No.

Yes. The OP did not say Connections (plural) but Connection (single).
And a Connection objection does have a collection - 2 in fact - the Errors
and Properties collection.
See
http://msdn2.microsoft.com/en-us/library/ms681546.aspx

He should be able to "walk" the Connection object's Property collection
which will contain more properties with an Open connection than a Closed
connection.

Stephen Howe


.

Relevant Pages

  • Re: Connection Collection
    ... And a Connection objection does have a collection - 2 in fact - the Errors ... and Properties collection. ... nonsense. ...
    (microsoft.public.data.ado)
  • Re: Connection Collection
    ... And a Connection objection does have a collection - 2 in fact - the Errors ... and Properties collection. ... Dan ...
    (microsoft.public.data.ado)
  • Re: NO COUNT
    ... Stephen Howe wrote: ... > issue it at the start of getting a connection and from then on, ... is necessary to turn on NOCOUNT. ... Zach ...
    (microsoft.public.sqlserver.programming)
  • Re: ADO Broken Connection
    ... > a way to programmatically determine a network connection loss in the ... Stephen Howe ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: DB Connection ID
    ... The ID that the DB holds for this connection. ... Iterating through the Connection Properties with a valid connection might ... Stephen Howe ...
    (microsoft.public.data.ado)