Identifies a loaded database to which a connection needs to be made when connecting to a database that is already running.

If you want to connect to a database that is not running, use the DatabaseFile (DBF) parameter.

Usage

Running local databases or network servers

Values

String

Default

There is no default setting.

Remarks

Whenever a database is started on a server, it is assigned a database name, either by the administrator using the -n option, or by the server using the base of the file name with the extension and path removed.

You can only use the database name utility_db to connect to the SQL Anywhere utility database. See Using the utility database.

If the database you want to connect to is already running, you should specify the database name rather than the database file.

A connection will only occur if the name of the running database matches the name that is specified in the DatabaseName (DBN) parameter.

See also

• Connection parameters
• Resolving connection parameter conflicts
• DatabaseName protocol option [DBN]

Example

To start a database file named cities.db and rename the database Kitchener, you can use the following command:

dbeng11 cities.db -n Kitchener

Assuming you have run the above command, you can successfully connect to the running database named Kitchener as follows:

DBN=Kitchener

Alternatively, you could use the following to successfully connect to the running database named Kitchener:

DBN=Kitchener;DBF=cities.db

However, specifying the following would fail to connect to the database named Kitchener:

DBF=cities.db