StarQuest Technical Documents

How to Enable ODBC Connection Pooling

Last Update: 26 June 2008
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 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. 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 information in technical documents may be gathered from various sources, including IBM, Microsoft, and other organizations.