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.
DBF=ul-db
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.
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.
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" |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |