SQL Anywhere® Server - Database Administration  > Connection Parameters and Network Protocol Options  > Connection parameters

AutoStop connection parameter [ASTOP]

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

Embedded databases

YES, NO

YES

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.

• How connection parameters work
• Connection parameter tips