Re: Connection Collection


"AK" <nospam@xxxxxxxxxxx> wrote in message
news:ew7UVafDHHA.3676@xxxxxxxxxxxxxxxxxxxxxxx
Is there such a thing as a Connection Collection??.

I know that there are forms collections and that I can loop thru the
collection to unload each form but is something like this available for
connections???


Still learning

AK


No.

ADO uses connection pooling which lives in the bowels of ADO/OLE DB.

It also sounds like you are confusing ADODB.Connection Objects with database
'connections'. They are not the same. Consider that with connection pooling
the actual number of Connection Objects likely doesn't correlate with the
actual number of database connections you have open.

Google for "ado connection pooling <your database>" for details.

-ralph



.

Relevant Pages

  • Re: ado connection object in vb6
    ... "Global connection objects are bad in so many ways. ... The key is that ADO uses 'connection pooling'. ... "Pooling in the Microsoft Data Access Components" ...
    (microsoft.public.vb.database.ado)
  • Re: pooled connection myth
    ... grouping is only done at the resource driver ... There is no reusability of connection objects created ... > connection objects, necessarily, those connection objects go away. ... You're right that a regular JDBC driver doesn't support connection pooling at all. ...
    (comp.lang.java.programmer)
  • Re: pooled connection myth
    ... There is much to be gained by reusing known open connection objects, ... grouping is only done at the resource driver ... >You're right that a regular JDBC driver doesn't support connection pooling at all. ...
    (comp.lang.java.programmer)
  • Re: Database Connection Question
    ... > I have a question for you, it involves IIS and database connections. ... > Common sense dictated we should only open the connection once, ... > and close it when that session expires or the window is closed. ... will minimize the number of actual opens and closes. ...
    (microsoft.public.inetserver.asp.db)
  • Re: pooled connection myth
    ... the usefulness of concurrent sharing for connection objects varies by the ... the Connection object does contain state information. ... Other types of resources, including ... assertions about connection pooling in general which aren't valid. ...
    (comp.lang.java.programmer)