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

AutoStart connection parameter [ASTART] Next Page

AutoStop connection parameter [ASTOP]


Controls whether a database is stopped as soon as there are no more open connections.

Usage

Embedded databases

Values

YES, NO

Default

YES

Remarks

By default, any server that is started from a connection string is stopped when there are no more connections to it. Also, any database that is loaded from a connection string is unloaded as soon as there are no more connections to it. This behavior is equivalent to AutoStop=YES.

If you supply AutoStop=NO, any database that you start in that connection remains running when there are no more connections to it. As a consequence, the database server remains operational as well.

The AutoStop (ASTOP) connection parameter is used only if you are connecting to a database that is not currently running. It is ignored if the database is already started.

See also