KB189410 - How To Enable or Disable Connection Pooling in IIS 4.0

Article ID: 189410

Article Last Modified on 6/23/2005

Microsoft Internet Information Server 4.0

This article was previously published under Q189410

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SUMMARY

ODBC connection pooling is enabled by default for ODBC drivers installed with Microsoft Option Pack 4.0. In Internet Information Server (IIS) 4.0 this setting is handled on a driver-by-driver basis. This article describes how to enable or disable this setting for any given ODBC driver.

MORE INFORMATION

ODBC connection pooling is configured through a registry setting saved with the ODBC driver information. This can be found in the Windows registry at the following location:

   \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\<drivername>

Where <drivername> is the name of the ODBC driver in question. Connection pooling is configured by setting the STRING value CPTIMEOUT to a non-zero value. This value is the number of seconds a connection is held in the pool before being discarded. Setting CPTIMEOUT to 0 disables connection pooling. If the CPTIMEOUT value does not exist, connection pooling will be disabled for that driver.

REFERENCES

For information on setting this value programmatically, see the following articles in the Microsoft Knowledge Base:

164221 INF: How to Enable Connection Pooling in an ODBC Application

166083 INF: How to Enable Connection Pooling in an OLE DB Application

Keywords: kbhowto KB189410