OdbcConnection.ReleaseObjectPool Method


Indicates that the ODBC Driver Manager environment handle can be released when the last underlying connection is released.

 static void ReleaseObjectPool();
public static void ReleaseObjectPool ();
static member ReleaseObjectPool : unit -> unit
Public Shared Sub ReleaseObjectPool ()


ReleaseObjectPool can be called to release the ODBC environment handle. You might want to call this method if, for example, the connection object will not be used again. When all connections in the environment are closed, the environment can be disposed. Note that calling the method alone does not actually release the active connections that exist in the environment.

The following must occur before the environment is finally disposed:

  1. Call Close to release the OdbcConnection object from the environment.

  2. Allow each connection object to time out.

  3. Call ReleaseObjectPool.

  4. Invoke garbage collection.

Conversely, if you call Close on all active connections, and invoke garbage collection, but do not call ReleaseObjectPool, the resources reserved for the environment remain available.

After an environment handle is released, a request for a new OdbcConnection creates a new environment.

Applies to

See also