RetryConnectionTimeout connection parameter [RetryConnTO]

Instructs the client library (dblib, ODBC, ADO, and so on) to keep retrying the connection attempt, as long as the server is not found, for the specified period of time.

Usage

Anywhere

Values

Integer

Default

0

Remarks

The value specified by this connection is a timeout, in seconds. It is not a counter of the number of times to retry the connection attempt. The default value of zero indicates that the connection attempt should only be tried once. There is a half-second delay between iterations, and the retries only occur if the connection attempt failed because the database server was not found. Any other error is returned immediately. If the database server is not found, the connection attempt will take at least as long as the time specified by the RetryConnectionTimeout connection parameter.

Note that the default TCP timeout is 5 seconds, so if your connection string contains a value for RetryConnTO that is less than 5, for example LINKS=tcp;RetryConnTO=3, then the connection attempt still takes 5 seconds.

See also
Example

The following connection string fragment tells the client library to continue to retry the connection attempt for at least 5 seconds:

...RetryConnTO=5;...