skip to main content
Using the Driver : Using DataDirect Connection Pooling
  

Try DataDirect Drivers Now

Using DataDirect Connection Pooling

This information pertains to Windows This information pertains to UNIX and Linux.
Supported on Windows, UNIX, and Linux only.
The SQL Server Wire Protocol driver supports DataDirect Connection Pooling on Windows, UNIX, and Linux platforms. Connection pooling allows you to reuse connections rather than creating a new one every time the driver needs to establish a connection to the underlying database. The driver enables connection pooling without requiring changes to your client application.
Note: Connection pooling works only with connections that are established using SQLConnect or SQLDriverConnect with the SQL_DRIVER_NO_PROMPT argument and only with applications that are thread-enabled.
DataDirect connection pooling that is implemented by the DataDirect driver is different than connection pooling implemented by the Windows Driver Manager. The Windows Driver Manager opens connections dynamically, up to the limits of memory and server resources. DataDirect connection pooling, however, allows you to control the number of connections in a pool through the Min Pool Size (minimum number of connections in a pool) and Max Pool Size (maximum number of connections in a pool) connection options. In addition, DataDirect connection pooling is cross-platform, allowing it to operate on UNIX and Linux. See "Summary of Pooling-Related Options" for details about how the connection options manage DataDirect connection pooling.
Important: On Windows, do not use connection pooling for the Windows Driver Manager at the same time as DataDirect connection pooling.
* Creating a Connection Pool
* Adding Connections to a Pool
* Removing Connections from a Pool
* Handling Dead Connections in a Pool
* Connection Pool Statistics
* Summary of Pooling-Related Options