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 » The Database Server » The SQL Anywhere database server » Database server options

-m server option Next Page

-n server option

Sets the name of the database server.


{ dbsrv10 | dbeng10 } -n database-filename...

Applies to

All operating systems and servers.


By default, the database server receives the name of the first database file with the path and extension removed. For example, if the server is started on the file samples-dir\demo.db and no -n option is specified, the name of the server is demo.

The server name is interpreted according to the character set of the computer, as no database collation exists at startup time. Multibyte characters aren't recommended in server names.

Database server names must be valid identifiers. Long database server names are truncated to different lengths depending on the protocol. Database server names cannot:

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

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

The server name specifies the name to be used in the EngineName (ENG) connection parameter of client application connection strings or profiles. With shared memory, there is a default database server that is used if no server name is specified, provided that at least one database server is running on the computer.

Running multiple database servers with the same name is not recommended.

There are two -n options

The -n option is positional. If it appears before any database file names, 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 database server SERV and the database DATA:

dbsrv10 -n SERV sales.db -n DATA

See -n database option.

See also