What is the Connection Pooling tab for?
Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Use this tab to alter the connection retry wait time and time-out period for a selected driver when using connection pooling. You can also enable and disable performance monitoring, which records a number of connection statistics.
The table below describes the controls on the Connection Pooling tab.
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.
Enable Enables performance-monitoring counters for connection pooling. For more information about performance monitoring, go to Setting ODBC Connection Pooling Options on the Microsoft website.
Disable Disables performance-monitoring counters for connection pooling. For more information about performance monitoring, go to Setting ODBC Connection Pooling Options on the Microsoft website.
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 topic.