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 options

UltraLite DBF creation option

Specify the path and file name for an UltraLite database.

Use this creation option to specify the path and file name for a new database file or when connecting to an existing database file.

  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.


If you are connecting to multiple databases on different devices from a single connection string, you can use the following options to name platform-specific alternates:

  • desktop:DBF
  • device:DBF

If specified, these platform-specific creation options take precedence over DBF.

The value of DBF must meet the file name requirements for the platform.

  • Windows Mobile

    If you are deploying to a Windows Mobile device, UltraLite administration tools running on the Windows desktop can connect to an UltraLite database on an attached Windows Mobile device. To identify a file on a Windows Mobile device, you must specify the required absolute path, and use the wce: file prefix.

    You cannot use the wce: file prefix in an application running on the Windows Mobile device.

Any leading or trailing spaces in option values are ignored. The value cannot include leading single quotes, leading double quotes, or semicolons.