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

DatabaseName connection parameter [DBN] Next Page

DatabaseSwitches connection parameter [DBS]

Provides database-specific options when starting a database.


Connecting to a server when the database is not loaded. This connection parameter autostarts a server with the specified database and options if a server is not already running.




No options.


You should supply DatabaseSwitches only if you are connecting to a database that is not currently running. When the server starts the database specified by DatabaseFile, the server uses the supplied DatabaseSwitches to determine startup options for the database.

Only database options can be supplied using this parameter. Server options must be supplied using the StartLine connection parameter.

See Database options.


The DatabaseName (DBN) connection parameter is recommended for naming databases, rather than using the -n option with the DatabaseSwitches (DBS) connection parameter.

See also

The following command, entered all on one line at a command prompt, connects to the default database server, loads the database file demo.db (DatabaseFile (DBF) connection parameter), names it my-db (DatabaseName (DBN) connection parameter) and starts it in read-only mode (-r option).

dbisql -c "UID=DBA;PWD=sql;DBF=samples-dir\demo.db;DBN=my-db;DBS=-r"

For information about samples-dir, see Samples directory.