Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters


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.








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

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