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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connection Parameters and Network Protocol Options » Connection parameters

PrefetchRows connection parameter [PROWS] Next Page

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;...