AutoStop connection parameter [Astop]

To prevent unloading of a database as soon as there are no more open connections to it.

Embedded databases

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, then any database that you start in that connection is not unloaded when there are no more connections to it. As a consequence, the database server will not be shut down either.

The AutoStop parameter is used only if you are connecting to a database that is not currently running. It is ignored if the database is already loaded.

The following Windows connection profile prevents the database from being unloaded when the connection is dropped:

[Sample Embedded Database]
DatabaseFile=c:\sybase\ASIQ-12_6\demo\asiqdemo.db
Autostop=No
UserID=DBA