Attribute

LoadBalanceTimeout (LBT)

Purpose

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.

Determines whether the driver works with applications using multiple ODBC threads.

Valid Values

0 | x

where:

x

is a positive integer that specifies a number of seconds.

Behavior

If set to 0, inactive connections are kept open.

If set to x, inactive connections are closed after the specified number of seconds passes.

Notes

• The Min Pool Size option may cause some connections to ignore this value.
• This connection option can affect performance.

Default

0 (Disabled)

See also

See Performance Considerations for details.

GUI Tab

Pooling tab