skip to main content
Using the ADO.NET Client : Specifying Connection Options : Connection Retry Delay
 

Connection Retry Delay

Property

ConnectionRetryDelay

Description

Specifies the number of seconds the data provider waits after the initial unsuccessful connection attempt before retrying a connection to the primary server, and, if specified, the alternate servers.
Note: This option has no effect unless the Connection Retry Count connection string option is set to an integer value greater than 0.

Valid Values

0 to x
where x is a positive integer from 1 to 65535.
If set to 0, there is no delay between retrying the connection.
If set to x, the data provider waits the specified number of seconds between connection retry attempts.

Default

3