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 NT 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 NT 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.

• Opening UltraLite connections with connection strings
• Specifying file paths in an UltraLite connection parameter
• Precedence of connection parameters for UltraLite administration tools
• UltraLite DBF connection parameter
• UltraLite for C/C++: Connecting to a database
• UltraLite for C/C++: OpenConnection method
• UltraLite for embedded SQL: Connecting to a database
• UltraLite for M-Business Anywhere: Connecting to an UltraLite database
• UltraLite for M-Business Anywhere: openConnection method
• UltraLite.NET: Connecting to a database
• UltraLite.NET: Open method

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"