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
PALM_FILE=name
Syntax 2: file-based stores
PALM_FILE=vfs:[ volume-label:| volume-ordinal:]filename
Default
  • 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.

Remarks

You should use the PALM_FILE connection parameter for UltraLite client applications that use the same connection string to connect to a Palm device, and 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
Example

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;
NT_FILE=c:\test\MyTestDB.udb;CE_FILE=\database\MyCEDB.udb;PALM_FILE=MyPalmDB_MyCreatorID")