Purpose

Specifies whether the driver tries to connect to the primary and an alternate server at the same time. This property is ignored if the FailoverMode property is set to connect.

Valid Values

true | false

Behavior

If set to true, the driver tries to connect to the primary and an alternate server at the same time. This can be useful if your application is time-sensitive and cannot absorb the wait for the failover connection to succeed.

If set to false, the driver tries to connect to an alternate server only when failover is caused by an unsuccessful connection attempt or a lost connection. This value provides the best performance, but your application typically experiences a short wait while the failover connection is attempted.

Notes

  • The AlternateServers property specifies one or multiple alternate servers for failover.

Default

false

Data Type

boolean

See also

Configuring Failover