UltraLite C++ User's Guide
Understanding UltraLite Development
A set of runtime libraries is available for some platforms when using UltraLite for C++. These include, for Windows CE and Windows XP, a database engine that permits multi-process access to the same database.
The runtime libraries are provided in the UltraLite\ce, UltraLite\palm, and UltraLite\win32 subdirectories of your SQL Anywhere installation.
The UltraLite\win32\386 directory contains libraries for Windows operating systems other than Windows CE. These include the following:
ulrt9.dll An ANSI character set library. To use this library, link your application against the import library UltraLite\win32\386\ulimp.lib. Databases created using this library cannot be deployed to Windows CE devices, as Windows CE uses Unicode.
ulrtw9.dll A Unicode character set library. To use this library, link your application against the import library UltraLite\win32\386\ulimpw.lib. Databases created using this library can be deployed to Windows CE devices.
When linking against this library, be sure to specify the following compilation options:
/DUNICODE /DUL_USE_DLL
ulrtcw9.dll A Unicode character set library for use with the UltraLite engine for multi-process access to an UltraLite database. To use this library, link your application against the import library UltraLite\win32\386\ulimpcw.lib. Databases created using this library can be deployed to Windows CE devices, but require distribution of the UltraLite engine as well as the DLL.
When linking against this library, be sure to specify the following compilation options:
/DUNICODE /DUL_USE_DLL
The UltraLite engine is an executable program for Windows and Windows CE. It acts as a database server for UltraLite databases, providing same-machine access to the database from multiple applications.
You can start the UltraLite engine in the following ways:
Manually starting the UltraLite engine Enter the following command at a command prompt:
dbuleng9
Letting the application start the UltraLite engine When your UltraLite for C++ application is linked against the ulimpcw.lib library, it starts the UltraLite engine on the first connection attempt. If an engine is already running, it uses that engine to connect to the database.
To specify the location of dbuleng9.exe, use the StartLine connection parameter when connecting to the database for the first time. If the StartLine parameter is not provided, the client looks for dbuleng9.exe in the \Windows, root (\), and \UltraLiteDB directories in that order on Windows CE and in the win32 subdirectory of your SQL Anywhere installation on other Windows operating systems.
When connecting to a database using the UltraLite engine, you must supply the user ID (uid) and password (pwd) connection parameters.
You can stop the UltraLite engine manually using the dbulstop utility. Alternatiively, you can let the application stop the engine: the last application to disconnect from the database stops the UltraLite engine automatically.