skip to main content
Using the ADO.NET Client : Specifying Connection Options : Load Balancing
 

Load Balancing

Property

LoadBalancing

Description

Determines whether the data provider uses client load balancing in its attempts to connect to primary and alternate database servers. The list of alternate servers is specified by the Alternate Servers connection option.

Valid Values

True | False
If set to True, the data provider attempts to connect to the database servers in random order. Refer to the OpenAccess SDK Administrator’s Guide for more information about load balancing.
If set to False, client load balancing is not used and the data provider connects to each server based on its sequential order (primary server first, then, alternate servers in the order they are specified).
Note: This option has no effect unless alternate servers are defined for the Alternate Servers connection string option.
The Load Balancing connection string option is an optional setting that you can use in conjunction with connection failover. Refer to the OpenAccess SDK Administrator’s Guide for a discussion of connection failover and for information about other connection options that you can set for this feature.

Default

False