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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite Database Reference » UltraLite connection parameters reference


UltraLite PALM_FILE connection parameter

Names the new database file when creating a database. When opening a connection to an existing database, this connection parameter identifies the database.

Syntax 1: record based stores
Syntax 2: file-based stores
PALM_FILE=vfs:[ volume-label:| volume-ordinal:]filename
  • DBF connection parameter.
  • If you do not set a value for the DBF connection parameter or this connection parameter, then the default value is ulstore.udb.

You should use the PALM_FILE connection parameter for UltraLite client applications that use the same connection string to connect to a Palm device, as well as other platforms.

This connection parameter takes precedence over the DBF connection parameter. If you are connecting from an UltraLite administration tool, or your connection object only connects to a Palm OS database, use DBF.

The value of PALM_FILE must meet the file name requirements for Palm OS platforms.

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, you must use the DBF connection parameter and 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, the .pdb extension is dropped. Your application must then connect to the database using the Palm_FILE connection parameter and no extension.

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

On VFS stores, always specify the absolute file path. If directories are specified in the full path name, they are created if they do not already exist.

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.

See also

The following example creates a new connection and identifies different database files for the desktop, Palm OS, and Windows Mobile platforms:

Connection = DatabaseMgr.OpenConnection("UID=JDoe;PWD=ULdb;