skip to main content
Using the ODBC Client : Specifying ODBC Connection Attributes : Load Balancing
 

Load Balancing

Attribute

LoadBalancing (LB)

Configuration

Client/server configuration only

Description

Determines whether the driver uses client load balancing in its attempts to connect to primary and alternate database servers.
Note: This attribute has no effect unless alternate servers are defined for the AlternateServers connection string attribute.
The LoadBalancing connection string attribute is an optional setting that you can use in conjunction with connection failover.
See Using Client Load Balancing for more information and for information about other connection string attributes that you can set for this feature.

Valid Values

0 | 1
If set to 1, the driver attempts to connect to the database servers in random order.
If set to 0, client load balancing is not used and the driver connects to each database server based on its sequential order (primary server first, then, alternate servers in the order they are specified).

Default

0

GUI Tab

Failover tab