Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite connection parameters

UltraLite DBN connection parameter

Differentiates databases by name when applications connect to more than one database.

Syntax
DBN=db-name
Default

None.

Behavior
  1. On connect, look to see if the database is already running. If DBN is specified, look for a matching database and connect if found, proceed to auto-start if not.

  2. If DBF is specified, look for a matching database (identical filename) and connect if found, proceed to auto-start if not.

  3. If neither DBN nor DBF is specified, and a single database is running, connect to it.

  4. A database is auto-started when required if DBF is specified. If DBN is also specified, it becomes the name of the running database, otherwise a name is generated from the base filename.

Remarks

UltraLite sets the database name after the database has been opened. Client applications can then connect to this database via its name instead of its file.

Any leading or trailing spaces in parameter values are ignored. This connection parameter's value cannot include leading single quotes, leading double quotes, or semicolons.

Example

Use the following parameters to connect to the running UltraLite database named Kitchener:

DBN=Kitchener;DBF=cities.udb