Connection Pooling Tab

Lets you alter the connection retry wait time and connection time-out period for a selected driver when using connection pooling and also lets you enable and disable performance monitoring, which records a number of connection statistics. Connection pooling enables your application to use a connection from a pool of connections that do not need to be reestablished for each use. Once a connection has been created and placed in a pool, an application can reuse that connection without performing the complete connection process, improving performance.

Control Description
ODBC Drivers Lists the name of each installed ODBC driver with its connection pooling time-out option. To set the time-out option, double-click the ODBC driver name.
Connection Pooling Timeout Sets the connection pooling time-out, in seconds, for the selected driver. To set connection pooling attributes, double-click the driver name. The Set Connection Pooling Attributes dialog box appears. You can set a time period that unused connections remain in the pool and also activate connection pooling for the selected driver.
Enable Enables performance-monitoring counters for connection pooling. For more information about performance monitoring, see the ODBC Programmer's Reference.
Disable Disables performance-monitoring counters for connection pooling. For more information about performance monitoring, see the ODBC Programmer's Reference.
Retry Wait Time Specifies, in seconds and in fewer than six numerals, how long the ODBC Driver Manager waits before making connection retries to a database server.
OK Accepts changes to connection pooling settings and closes the ODBC Data Source Administrator dialog box.
Cancel Closes the ODBC Data Source Administrator dialog box without accepting changes to settings.
Apply Accepts changes to connection pooling settings and leaves the ODBC Data Source Administrator dialog box open.
Help Displays this Help screen.