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 |
Disable |
Disables performance-monitoring counters for connection pooling. For more information about performance monitoring, see the |
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. |