Connection pooling

Last modified: July 25, 2025

The driver supports connection pooling, which improves performance and scalability by reusing existing database connections. Instead of opening a new connection for each request, the driver retrieves a connection from a pre-established pool, reducing the time and resources required to establish new connections. This is especially beneficial in scenarios that involve frequent connect/disconnect operations.

By default, an unused connection is kept in a pool for 60 seconds.

To change the connection pool timeout or disable connection pooling in ODBC Data Source Administrator:

1. Select the Connection Pooling tab.

2. Double-click Devart ODBC Driver for Salesforce.

The Connection Pooling tab in ODBC Data Source Administrator

3. In the Set Connection Pooling Attributes dialog, configure connection pooling:

  • To change the connection pool timeout, select Pool Connections to this driver and enter the new time (in seconds) for connections to remain in the pool.

  • To disable connection pooling, select Don’t pool connections to this driver.

4. Click OK.

The Set Connection Pooling Attributes dialog in ODBC Data Source Administrator

5. In ODBC Data Source Administrator, click Apply to save the settings.

ODBC Data Source Administrator showing the changed Pool Timeout value