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

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Consolidated Databases

How remote tables relate to consolidated tables Next Page

Setting up a consolidated database

Setup scripts

To set up a database so that it can be used as a MobiLink consolidated database, you must run a setup script. Your SQL Anywhere installation includes a script for each of the supported RDBMSs. These scripts are all located in the MobiLink\setup subdirectory of your SQL Anywhere installation.


If you use the Create Synchronization Model wizard to create your MobiLink application, the wizard will check whether your database needs to be set up, and will automatically run the appropriate setup script. See Introduction to MobiLink models.

The MobiLink setup script adds MobiLink system tables, stored procedures, triggers, and views to your database. These tables and procedures are required for MobiLink synchronization.

For information about the MobiLink system tables that are installed, see MobiLink Server System Tables.

For information about the stored procedures that are installed, see MobiLink system procedures.

You can view each setup script in a text editor if you want to check what it does.


The database user who runs the setup scripts is given permission to update the MobiLink system tables, which is required to start the MobiLink server and to configure MobiLink. See Required permissions.

For instructions on how to run the setup scripts, see the section for your RDBMS:

ODBC connection

The MobiLink server needs an ODBC connection to your consolidated database. You must configure the appropriate ODBC driver for your server and create an ODBC data source for the database on the computer where your MobiLink server is running.

For more information about MobiLink ODBC drivers, see iAnywhere Solutions ODBC Drivers for MobiLink.

For updated information and complete functional specifications of the ODBC drivers you can use with MobiLink, see [external link]