skip to main content
Using the Driver : Configuring and Connecting to Data Sources : Data Source Configuration through a GUI : Pooling Tab
  

Try DataDirect Drivers Now
Pooling Tab
The Pooling Tab allows you to specify your pooling data source settings. On this tab, provide values for the options in the following table; then, click Apply. The fields are optional unless otherwise noted. See "Using DataDirect Connection Pooling" for a general description of connection pooling.
Figure 5. Pooling tab
The Pooling Tab of the ODBC SQL Server Wire Protocol Driver Setup dialog box
Connection Options: Pooling
Description
Specifies whether to use the driver’s connection pooling.
If enabled, the driver uses connection pooling.
If disabled, the driver does not use connection pooling.
Default: Disabled
Determines whether the state of connections that are removed from the connection pool for reuse by the application is reset to the initial configuration of the connection.
If enabled, the state of connections removed from the connection pool for reuse by an application is reset to the initial configuration of the connection. Resetting the state can negatively impact performance because additional commands must be sent over the network to the server to reset the state of the connection.
If disabled, the state of connections is not reset.
Default: Disabled
The maximum number of connections allowed within a single connection pool. When the maximum number of connections is reached, no additional connections can be created in the connection pool.
Default: 100
The minimum number of connections that are opened and placed in a connection pool, in addition to the active connection, when the pool is created. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value.
If set to 0, no connections are opened in addition to the current existing connection.
If set to x, the start-up number of connections in the pool is x in addition to the current existing connection.
Default: 0
Specifies the number of seconds to keep inactive connections open in a connection pool. An inactive connection is a database session that is not associated with an ODBC connection handle, that is, a connection in the pool that is not in use by an application.
If set to 0, inactive connections are kept open.
If set to x, inactive connections are closed after the specified number of seconds passes.
Default: 0 (inactive connections are kept open.)
If you finished configuring your driver, proceed to Step 6 in "Data Source Configuration through a GUI (Windows)." Optionally,you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:
*General tab allows you to configure options that are required for creating a data source.
*Advanced tab allows you to configure advanced behavior.
*Security tab allows you to specify security data source settings.
*Failover tab allows you to specify failover data source settings.
*Bulk tab allows you to specify data source settings for DataDirect Bulk Load.