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

UltraLite DBF connection parameter

Performs two different functions:

• When creating a database, this parameter names the new database file.

• When opening a connection, this parameter indicates which database file you want to load and connect to.

Typically used when targeting a single platform or using UltraLite administration tools.

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:

• CE_FILE
• PALM_FILE
• NT_FILE
• SYMBIAN_FILE

DBF=ul-db

Depends on the platform:

• 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 CE  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.

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

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

Because they are aliases, if DBF is used concurrently, the last one specified takes precedence.

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

If you are deploying to a Windows CE device, UltraLite utilities and wizards can administer an UltraLite database on an attached CE device. To identify a file on a CE device, ensure specify the required absolute path and use the wce:\ prefix as illustrated by the Windows CE example below.

Any leading or trailing spaces in parameter values are ignored. This connection parameter's value cannot include leading single quotes('), leading double quotes ("), or semi-colons(;).

• Opening UltraLite connections with connection strings
• Specifying file paths in an UltraLite connection parameter
• Precedence of parameters for UltraLite administration tools
• UltraLite DBN connection parameter
• UltraLite CE_FILE connection parameter
• UltraLite PALM_FILE connection parameter
• UltraLite NT_FILE connection parameter
• UltraLite SYMBIAN_FILE 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 AppForge: Connecting to an UltraLite database
• UltraLite for AppForge: OpenConnection method
• 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

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 CE device, use the following connection string:

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