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. After a connection has been created and placed in a pool, an application can reuse that connection without performing the complete connection process. This improves 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.