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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases » Connecting to an UltraLite database


UltraLite database connection parameters

UltraLite supports the following connection parameters.

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

Determines when committed transactions are flushed to storage after a commit call. See UltraLite COMMIT_FLUSH connection parameter.

CON Specifies a name of the current connection. See UltraLite CON connection parameter.
DBF, CE_FILE, desktop, device, and NT_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:

DBN Identifies a running database by name rather than file name. See UltraLite DBN connection parameter.
DBKEY Specifies the encryption key used to encrypt the database. See UltraLite DBKEY connection parameter.
MIRROR_FILE Specifies the name of a database mirror file. See UltraLite MIRROR_FILE 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. See UltraLite START connection parameter.
TEMP_DIR Specifies the name of the directory (which must already exist) into which UltraLite will place a temporary file (with a name derived from the database name). See UltraLite TEMP_DIR 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

Supplying UltraLite connection parameters
Specifying file paths in an UltraLite connection parameter
Opening UltraLite connections with connection strings
Assembling parameters into UltraLite connection strings