UltraLite supports the following connection parameters.
|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.|
Supplying 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|