DataDirect connection pooling is available in the following DataDirect Connect Series forODBC drivers:
DB2 Wire Protocol
Greenplum Wire Protocol
MySQL Wire Protocol
Oracle Wire Protocol
Oracle
PostgreSQL Wire Protocol
SQL Server Wire Protocol
Sybase Wire Protocol
Sybase IQ Wire Protocol
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 DataDirect Connect Series forODBC drivers enable 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 the "Connection Option Descriptions" section in each driver’s chapter for details about how the connection options manage DataDirect connection pooling.
On a Windows system, do not use both Windows Driver Manager connection pooling and DataDirect connection pooling at the same time.
DB2 Wire Protocol