Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » UltraLite - C and C++ Programming » Application development » UltraLite C++ application development


Connecting to an UltraLite database

UltraLite applications must connect to the database before performing operations on its data. This section describes how to connect to an UltraLite database.

The ULDatabaseManager class is used to open a connection to a database. The ULDatabaseManager class returns a non-null ULConnection object when a connection is established. Use the ULConnection object to perform the following tasks:

  • Commit or roll back transactions.

  • Synchronize data with a MobiLink server.

  • Access tables in the database.

  • Work with SQL statements.

  • Handle errors in your application.

Ensure you specify a writable path for the database file. Use the NSSearchPathForDirectoriesInDomains function to query the NSDocumentDirectory, for example.


You can find sample code in the %SQLANYSAMP12%\UltraLite\CustDB\ directory.

 Connect to an UltraLite database
  1. Initialize the ULDatabaseManager object and enable features in UltraLite using the following code:

    if( !ULDatabaseManager::Init() ) {
        return 0;
    // Use ULDatabaseManager.Fini() when terminating the app.
  2. Open a connection to an existing database or create a new database if the specified database file does not exist using the following code:

    ULConnection * conn;
    ULError ulerr;
    conn = ULDatabaseManager::OpenConnection( "dbf=sample.udb;dbkey=aBcD1234", &ulerr );
    if( conn == NULL ) {
        if( ulerr.GetSQLCode() == SQLE_ULTRALITE_DATABASE_NOT_FOUND ) {
            conn = ULDatabaseManager::CreateDatabase( "dbf=sample.udb;dbkey=aBcD1234", &ulerr );
            if( conn == NULL ) {
                // write code that uses ulerr to determine what happened
                return 0;
            // add code to create the schema for your database
        } else {
            // write code that uses ulerr to determine what happened
            return 0;
    assert( conn != NULL );

    In this step, you declare a ULError object that contains error information in case the connection is not successful.

 Multi-threaded applications
 See also