desktop:DBF=path\db | temp_dir=\Temp

You should use the desktop connection parameter for UltraLite client applications that use the same connection string to connect to a Microsoft Windows or Mac device.

Colon (:) is considered to be a separator in addition to underscore (_). Options with a prefix take precedence over options without a prefix.

A temp_dir connection parameter is now available. This must name a directory (which already exists). UL will place the temporary file (with name still derived from the database name) in the specified directory, rather than beside the database file (the default and previous behavior). Specifying a temporary directory with faster I/O characteristics can improve the performance of things like temporary tables which are large relative to the cache size. Long-running transactions can also consume noticeable space in the temp file.

The value of desktop must meet the file name requirements for Windows or Mac. If you include an absolute path to the database, then all directories must exist before setting the path to this file. UltraLite does not create them automatically.

Any leading or trailing spaces in parameter values are ignored. This connection parameter's value cannot include leading single quotes, leading double quotes, or semicolons.

• UltraLite connection strings and parameters
• UltraLite file path formats in connection parameters
• Precedence of connection parameters for UltraLite administration tools
• UltraLite DBF connection parameter
• UltraLite for C/C++: Connecting to an UltraLite database
• ULDatabaseManager.OpenConnection method [UltraLite C++]
• UltraLite for embedded SQL: Connect to an UltraLite database
• UltraLite for M-Business Anywhere: Connect to an UltraLite database
• DatabaseManager.openConnection method [UltraLite for M-Business Anywhere]
• UltraLite.NET: Connecting to an UltraLite database
• ULConnection.Open method [UltraLite.NET]

The following example creates a new connection and identifies different database files for the Windows desktop and Windows Mobile platforms:

"desktop:DBF=C:\dir\db.udb; device:DBF=\SD Card\db.udb; device:temp_dir=\Temp; device:cache_size=4M"