OdbcConnection.ReleaseObjectPool Method ()

 

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

Namespace:   System.Data.Odbc
Assembly:  System.Data (in System.Data.dll)

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.

.NET Framework
Available since 1.1
Return to top
Show: