Kbase 20749: Check if an ODBC Application Enables OLE DB Resource Pooling
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to verify whether an ODBC application (such as an ASP application) enables OLE database resource pooling.
FIX:
You can verify whether an ODBC application enables OLE database resource pooling by turning on the tracing functionality for the ODBC data source panel.
An application must request that connection pooling in the Microsoft driver manager be enabled. The ODBC trace file shows calls to SQLSetEnvAttr with a parameter of SQL_ATTR_CONNECTION_POOLING and a value to indicate whether there is a pool for per environment or a pool per driver instance.
If this is not present in the trace file, it means the connection is pooled in an OLEDB resource pool. As a result, the driver most likely never receives a disconnect request. Disconnect requests can also be verified within the tracing file.