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 » Running the Database Server » Some common options

Using configuration files to store server startup options Next Page

Naming the server and the databases


You can use -n as a server option (to name the server) or as a database option (to name the database).

The server and database names are among the connection parameters that client applications may use when connecting to a database. The server name appears on the desktop icon and in the title bar of the Server Messages window.

Naming the server

Providing a database server name helps avoid conflicts with other server names on your network. It also provides a meaningful name for users of client applications. The server keeps its name for its lifetime (until it is shut down). If you don't provide a server name, the server is given the name of the first database started.

You can name the server by supplying a -n option before the first database file. For example, the following command starts a server on the sample database and gives the server the name Cambridge:

dbeng10 -n Cambridge samples-dir\demo.db

If you supply a server name, you can start a database server without starting a database. The following command starts a server named Galt with no database started:

dbeng10 -n Galt

The maximum length of the server name depends on the protocol being used:

Protocol Truncation length
TCP/IP 250 bytes
Shared memory 250 bytes
SPX 32 bytes

For more information about starting databases on a running server, see Starting and stopping databases.

Note

On Windows and Unix, version 9.0.2 and earlier clients cannot connect to version 10.0.0 and later database servers with names longer than the following lengths:

  • 40 bytes for Windows shared memory
  • 31 bytes for Unix shared memory
  • 40 bytes for TCP/IP
Naming databases

You may want to provide a meaningful database name for users of client applications. The database is identified by that name until it is stopped.

If you don't provide a database name, the default name is the root of the database file name (the file name without the .db extension). For example, in the following command the first database is named mydata, and the second is named mysales.

dbeng10 c:\mydata.db c:\sales\mysales.db

You can name databases by supplying a -n option following the database file. For example, the following command starts the sample database and names it MyDB:

dbeng10 samples-dir\demo.db -n MyDB
Case sensitivity

Server names and database names are case insensitive as long as the character set is single-byte. See Connection strings and character sets.