Connection Pooling Tab |
The Connection Pooling tab allows you to alter the connection retry wait time and connection timeout period for a selected driver when using connection pooling. It also allows you to enable and disable Performance Monitoring, which records a number of connection statistics.
Connection Pooling Timeout
The Connection Pooling Timeout section sets the connection pooling time-out, in seconds, for the selected driver. To set connection pooling attributes, double-click the driver name. In the Set Connection Pooling Attributes dialog, you can set a time period that unused connections remain in the pool and also activate connection pooling for the selected driver.
ODBC Drivers. Lists the name of each installed ODBC driver with its connection pooling time-out option; use the horizontal scroll bar to see the pooling time-out option. To set the time-out option, double-click the ODBC driver name.
PerfMon
The PerfMon section determines whether performance-monitoring counters for connection pooling are enabled or disabled. For more information about performance monitoring, see Microsoft's ODBC Programmer's Reference.
Enable. Enables performance-monitoring counters for connection pooling.
Disable. Disables performance-monitoring counters for connection pooling.
Retry Wait Time
The Retry Wait Time section specifies, in seconds and in fewer than six numerals, how long the ODBC Driver Manager waits before making connection retries to a database server.
User DSN Tab • System DSN Tab • File DSN Tab • Drivers Tab • Tracing Tab • About Tab • ODBC Data Source Administrator