Export (0) Print
Expand All

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 static void 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.

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft