StarQuest Technical Documents

How to Enable ODBC Connection Pooling

Last Update: 05 February 2009
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ019

Abstract

This document explains how to enable and configure ODBC connection pooling for use with Microsoft Transaction Server and Internet Information Server.

Solution

To enable connection pooling, you must set the ODBC Connection Pooling Attributes for StarSQL.

  1. Launch the ODBC Data Source Administrator (typically found in Control Panel, Administrative Tools).
  2. Under the Connection Pooling tab, double-click on the StarSQL 32 or StarSQL (64-bit) entry.
  3. Enable connection pooling by selecting the 'Pool Connections to this driver' radio button.
  4. Set the timeout value for the idle connections.
  5. Click OK to save the changes and exit the dialog.
  6. Click OK once more to close the ODBC Data Source Administrator.

Additional References

Microsoft Knowledge Base Article, How to Enable Connection Pooling in an ODBC Application (Article ID: 164221).

Microsoft Knowledge Base Article, Frequently Asked Questions About ODBC Connection Pooling (Article ID: 169470).

DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.