Both database servers and databases can be named. Since a database server can load several databases, the database name is
used to distinguish the different databases.
Database names cannot:
begin with white space, single quotes, or double quotes
end with white space
contain semicolons
be longer than 250 bytes
You can only use the database name utility_db to connect to the SQL Anywhere utility database. See Using the utility database.
The -n database option must be specified after the database-file, and applies only to that database.
If the database that is started is samples-dir\demo.db and no -n option is specified, the name of the database is demo.
The following example starts the database server with a cache size of 3 MB, loads the database, and names the database test.
Since no database server name has been specified, the server takes its name from the first database, so the server's name
is also test.
dbsrv12 -c 3MB "c:\mydata.db" -n "test"
There are two -n options
The -n option is position dependent. If it appears before a database file name, it is a server option and names the server.
If it appears after a database file name, it is a database option and names the database.
For example, the following command names the server SERV and the database DATA:
Syntax