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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite connection parameters

 

UltraLite DBF connection parameter

Names the new database file when creating a database. When opening a connection, this connection parameter indicates which database file you want to load and connect to.

Syntax
DBF=ul-db
Default
  • On desktop platforms   If you do not specify an NT_FILE or DBF value, UltraLite sets the file name to \UltraLiteDB\ulstore.udb.

  • On Windows Mobile   If you do not specify a CE_FILE or DBF value, UltraLite sets the file name to \UltraLiteDB\ulstore.udb.

  • On Palm OS   If you do not specify a PALM_FILE or DBF value, UltraLite sets the file name to ulstore.udb.

Remarks

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

If specified, these platform-specific connection parameters take precedence over DBF.

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

Palm OS   You cannot deploy databases to VFS volumes using the Palm install tool. Instead, you need to copy the database directly onto the media with a card reader, or some other tool.

If you are creating a file with the DBF parameter, you must name the database with a .pdb extension. This database name is used while administering the Palm OS database on the desktop. Administration tools and utilities can connect to the database with the DBF connection parameter and the database with the .pdb extension. Once you deploy the file to the device however, the .pdb extension is dropped. Your application must then connect to the database using the Palm_FILE parameter and no extension.

For example, if you name a file CustDB.pdb use DBF=CustDB.pdb with your administration tools desktop. Then, when the database is deployed to the device the application connects to the same database with PALM_FILE=CustDB.

Windows Mobile   If you are deploying to a Windows Mobile device, UltraLite utilities and wizards can administer 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:\ prefix.

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

See also
Examples

To connect to the database, MyULdb.udb, installed in the desktop directory c:\mydb, use the following connection string:

"DBF=c:\mydb\MyULdb.udb"

To connect to the same database that is deployed to the UltraLite folder of the attached Windows Mobile device, use the following connection string:

"DBF=wce:\UltraLite\MyULdb.udb"