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

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

• Opening UltraLite connections with connection strings
• Specifying file paths in an UltraLite connection parameter
• Precedence of connection parameters for UltraLite administration tools
• Registering the Palm creator ID
• UltraLite DBF connection parameter
• UltraLite for C/C++: Connecting to a database
• UltraLite for C/C++: OpenConnection function
• UltraLite for embedded SQL: Connecting to a database
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for M-Business Anywhere: openConnection method
• UltraLite.NET: Connecting to a database
• UltraLite.NET: Open method

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")