The following table summarizes connection properties which can be used to implement failover.

Table 1. Failover Properties
Property Characteristic
ConnectionRetryCount Specifies the number of times the driver retries connection attempts to the primary database server, and if specified, alternate servers before returning a connection failure.

If set to 0, the driver does not try to reconnect after the initial unsuccessful attempt.

If set to x, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an exception that is generated by the last database server to which it tried to connect.

The default is 5.

ConnectionRetryDelay Specifies the number of seconds the driver waits between connection retry attempts when ConnectionRetryCount is set to a positive integer.

If set to 0, the driver does not delay between retries.

If set to x, the driver waits between connection retry attempts the specified number of seconds.

The default is 1.

See also