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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Connecting to an UltraLite Database » Introduction to UltraLite database connections

Introduction to UltraLite database connections Next Page

List of UltraLite database connection parameters


Some of the connection parameters you configure overlap with properties you define at creation time. At creation time, you typically are defining the property required. At connection time, you must supply the value that was configured at creation time. It is important that you understand the differences and commonalities of these shared settings so you know what is expected and when.

Parameter nameDescription

CACHE_SIZE

Defines the size of the database cache. See UltraLite CACHE_SIZE connection parameter.

CON

Specifies a name of the current connection. See UltraLite CON connection parameter.

DBF, and CE_FILE, PALM_FILE, NT_FILE, or SYMBIAN_FILE

At creation-time these parameters set the location of the database. For subsequent connections, they tell UltraLite where to find the file.

You can use DBF if you are creating a single-platform application or are connecting to an UltraLite administration tool. Use the other platform-specific versions if you are programming an UltraLite client that connects to different platform-specific databases. See:

PALM_DB

AppForge development only. Sets the correct UltraLite creator ID so that creator ID is used, rather than the AppForge creator ID. Use this with the PALM_FILE parameter. See UltraLite PALM_DB connection parameter

DBN

Identifies a running database by name rather than file name. See UltraLite DBN connection parameter.

DBKEY

At creation-time, this parameter sets the encryption key to use. For subsequent connections, names and then passes the same encryption key for the database. If the incorrect key is named, the connection fails. See UltraLite DBKEY connection parameter.

PALM_ALLOW_BACKUP

Controls backup behavior over HotSync on Palm devices. See UltraLite PALM_ALLOW_BACKUP connection parameter .

PWD

At creation-time, sets the initial password for a user. For subsequent connections, supplies the password for the user ID. See UltraLite PWD connection parameter.

RESERVE_SIZE

Pre-allocates the file system space required for your UltraLite database without actually inserting any data. See UltraLite RESERVE_SIZE connection parameter.

START

Specifies the location of the UltraLite engine executable and then starts it. See UltraLite START connection parameter.

UID

At creation-time, sets the initial user ID. For subsequent connections, identifies a user to the database. The user ID must be one of up to four user IDs stored in the UltraLite database. See UltraLite UID connection parameter.

See also