RE: ADODB Connection.Close doesn't drop DB connection for ~60 seconds

From: v-kevy@xxxxxxxxxxxxxxxxxxxx (Kevin Yu [MSFT])
Date: Fri, 06 Jan 2006 05:52:21 GMT

Hi Nick,

As far as I can see, this is caused by connection pooling. After you have
closed the connection, the connection will not be closed actually. It is
put back into the pool. It will only be disposed after its lifetime has
expired or the application is over. Pooling connections can significantly
enhance the performance and scalability of your application.

I think you can disable connection pooling by adding "OLE DB Services=-4;"
in the OleDb connection string. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Prev by Date: Re: how to reference feild data -
Next by Date: Re: ado error and on error statement in vba
Previous by thread: connection string and ADO
Next by thread: RE: ADODB Connection.Close doesn't drop DB connection for ~60 seco
Index(es):
- Date
- Thread

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: MDAC question
... The MDAC downloads are labeled by the ... I suggested that the ADO data library
is ... He simply created a connection object and set its connection time ... Connection
pooling is just the kind of 'hidden' ... (microsoft.public.vb.general.discussion)
Re: MDAC question
... The MDAC downloads are labeled by the ... I suggested that the ADO data library
is ... He simply created a connection object and set its connection time ... Connection
pooling is just the kind of 'hidden' ... (microsoft.public.data.ado)
Re: MDAC question
... The MDAC downloads are labeled by the ... I suggested that the ADO data library
is ... He simply created a connection object and set its connection time ... Connection
pooling is just the kind of 'hidden' ... (microsoft.public.vb.database)
Re: Connection issues
... Connection pooling will have no impact on performance in a Windows Forms ...
Test for errors on the server by checking @@Error. ... > one SP inserts a row with an
identity column. ... (microsoft.public.dotnet.framework.adonet)