{ DatabaseSwitches | DBS }=database-server-options

Connecting to a database server when the database is not loaded. This connection parameter starts a database server automatically with the specified database and options if a database server is not 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.

• The SQL Anywhere database server
• Using connection parameters
• DatabaseName (DBN) connection parameter

The following command, entered 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.