UltraLite supports the following connection parameters.
| Parameter name | Description |
|---|---|
| CACHE_SIZE | Defines the size of the database cache. See UltraLite CACHE_SIZE connection parameter. |
| COMMIT_FLUSH |
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 alsoSupplying UltraLite connection parameters
Specifying file paths in an UltraLite connection parameter
Opening UltraLite connections with connection strings
Assembling parameters into UltraLite connection strings
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |