UltraLite User's Guide
  Tutorial: Build an Application Using Embedded SQL
    Building the sample embedded SQL UltraLite application
      Adding synchronization to your application

Running the sample application with synchronization

After you have made changes to the sample.sqc file, you must preprocess the altered sample.sqc file and rebuild ultutorial.exe.

This section assumes that you have completed the tutorial in the previous section and therefore have the appropriate project settings for the ultutorial project. If, however, you have not run the tutorial, you should refer to the guidelines in the previous section for including the appropriate project settings.

To rebuild the sample application

1. Ensure that the Adaptive Server Anywhere database server is still running.

2. Preprocess your new sample.sqc file.

   In the Workspace window, right click on sample.sqc and select Settings. Ensure that the Commands box contains the appropriate command for running the SQL preprocessor. Choose Build > Compile sample.sqc to recompile the altered file. A new sample.cpp file will be generated.

3. Build the executable.

   Select Build > Build ultutorial.exe to build the sample executable.

To run the sample application

1. Start the MobiLink synchronization server:

   • Select Start > Programs > Sybase SQL Anywhere 8 > MobiLink > Synchronization Server Sample, or

   • At a command prompt execute the following command (on a single line):

     dbmlsrv9 -c "DSN=UltraLite 9.0 Sample" 
     -o ulsync.mls -vcr -x tcpip

2. Run the application:

   • Select Build > Execute ultutorial.exe to run the sample application.

     The remote database will be synchronized with the consolidated database, filling the tables in the remote database with data. The select query in the sample application will be processed, and a row of query results will appear on the screen.