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

ForceStart connection parameter [FORCE] Next Page

Idle connection parameter


Specifies a connection's idle timeout period.

Usage

Anywhere except with TDS and Shared Memory connections. Shared Memory and TDS connections (including jConnect) ignore the SQL Anywhere Idle (IDLE) connection parameter.

Values

Integer

Default

None

Remarks

The Idle (IDLE) connection parameter applies only to the current connection. You can have multiple connections on the same server set to different timeout values.

If no connection idle timeout value is set, the idle timeout value is controlled by the setting on the server, which defaults to 240 minutes. In case of a conflict between timeout values, the connection timeout value supercedes any server timeout value whether specified or unspecified.

The minimum value for the IDLE connection parameter is 1 minute, and the maximum supported value is 32767 minutes. If you specify 0, idle timeout checking is turned off for the connection.

See also
Example

The following connection string fragment sets the timeout value for this connection to 10 minutes:

"ENG=myeng;LINKS=tcpip;IDLE=10"