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. |