Kbase P690: How to Configure ODBC Connection Pooling From The Windows Registry
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to configure ODBC connection pooling from the Windows Registry.
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FIX:
Configuring connection pooling from the Windows Registry:
For versions earlier than 3.5 of the ODBC core components, modify the Registry directly to control the connection pooling CPTimeout value.
Follow these steps:
1) Start the Registry Editor.
2) Locate the CPTimeout value for the driver in the appropriate
Registry key.
For example, the CPTimeout value for Microsoft SQL Server is
located under:
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/SQL Server.
The CPTimeout value for all drivers is located in the
Registry under the following key:
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Driver_Name
The default time-out value for connection pooling is 60
seconds (adequate for most installations).
The value setting for Wait Retry applies to all drivers on
the system, not just the one's for configuring it
the Data Source Administrator. This Wait Retry value is
stored in the registry under:
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/ODBC Connection Pooling.
Changes to this setting do not take effect until the pool is
released. Reboot the machine to put the changes into effect.