Setting up an UltraLite remote database

The following procedure creates a remote database for CustDB. The CustDB remote database must be an UltraLite database.

The application logic for the remote database is located in %SQLANYSAMP12%\UltraLite\CustDB. It includes the following files:

Embedded SQL logic The file custdb.sqc contains the SQL statements needed to query and modify information from the UltraLite database, and the calls required to start synchronization with the consolidated database.
C++ API logic The file custdbcpp.cpp contains the C++ API logic.
User-interface features These features are stored separately, in platform-specific subdirectories of Samples\UltraLite\CustDB.

You complete the following steps to install the sample application to a remote device that is running UltraLite:

The following example illustrates how to install the CustDB sample on a Windows desktop running against a DB2 consolidated database.

Ensure that the consolidated database is running:

For a DB2 LUW database, open a DB2 Command Window. Type the following command, where userid and password are the user ID and password for connecting to the DB2 LUW database:
db2 connect to CustDB user userid using password
Start the MobiLink server:

For a DB2 LUW database, at a command prompt, run the following command:
mlsrv12 -c "DSN=CustDB" -zp
Start the CustDB sample application:
1. Click Start » Programs » SQL Anywhere 12 » MobiLink » Synchronization Server Sample.
2. Enter a value of 50 for the employee ID and click OK.
  
  The application automatically synchronizes and a set of customers, products, and orders are downloaded to the application from the CustDB consolidated database.
Synchronize the remote application with the consolidated database.

From the File menu, choose Synchronize.

You only need to complete this step when you have made changes to the database.

Discuss this page in DocCommentXchange.