Re: TADOConnection.Close does not work

I have just checked and can confirm that Connection Pooling is actually
disabled on my development machine so, unfortunately, it looks like it is
not the cause of my problem.

"Steve Bailey" <sbailey@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:462c906d@xxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for that, Vitali.

Is there any way I can switch off Connection Pooling (at least
temporarily) from within my application?

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:462c6c55$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Most probably you are observing ODBC connection pooling in action. -
"When the application releases the connection, the pool returns S_OK to
the user, simulating a successful disconnection from the database.
However, the actual connection is not released by ODBC but instead waits
in the pool. When the next request for a connection to the database that
has the same data source and user information comes in, it is satisfied
from the connection in the pool rather than by making a full connection
to the database."






.

Relevant Pages

  • Re: How to clear connection pool?
    ... SQLConnection (SQL Server database), the pool size can be configured. ... >> connection problems when 100+ people have been connecting to the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Connectivity/Windows Service
    ... OracleConnection probably maintains a connection pool, ... When you restart the database server, ... Does restarting your Windows Service machine help? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Max pool size reached exception when trying to open a new connection
    ... Private Function GoodDataReaderCode(ByVal dataReader As IDataReader) ... 'The underlying connection to the database remains open and ... prior to obtaining a connection from the pool. ...
    (microsoft.public.dotnet.framework)
  • C# Windows Forms -> Jet 4.0 Access = Slow Performance/File Lock Errors -- Possible Solution
    ... and it's little Jet 4 database for the last few days. ... I got several errors from the Jet engine when there were simultaneous ... Studio open with a connection to the database everything worked fine ... The connection pool will serve ...
    (microsoft.public.dotnet.languages.csharp)
  • Connection Pooling holding onto errors?
    ... writing a layer to create and maintain the database of our product. ... steps happen on their own...that is they each create a new connection ... step 3 throws an exception, even though it did succeed creating the ... requiring the pool to be clear explicitly. ...
    (microsoft.public.dotnet.framework.adonet)