SQL Anywhere consolidated database

Before running the setup script, you should be aware of the following requirements:

The database user who runs the setup script is expected to be the same one used to update the MobiLink system tables during synchronization. This user must be used to start the MobiLink server and to configure MobiLink applications. See Required permissions.
The RDBMS user that the MobiLink server uses to connect to the consolidated database must be able to use the MobiLink system tables, procedures, and so on, without any qualifiers (for example, SELECT * from ml_user). See MobiLink server system tables.

To set up SQL Anywhere to work as a MobiLink consolidated database, you must run a setup procedure that adds MobiLink system tables, stored procedures, triggers, and views that are required for MobiLink synchronization. There are multiple ways you can do this:

Run the syncsa.sql setup script, located in %SQLANY12%\MobiLink\Setup.
Check and update the MobiLink system setup from Sybase Central. See MobiLink system setup.

You must set up an ODBC DSN for your SQL Anywhere consolidated database. The ODBC driver for SQL Anywhere is installed with SQL Anywhere.

For information about the SQL Anywhere ODBC driver, see ODBC data sources.

See MobiLink isolation levels.

SQL Anywhere consolidated database

Permissions

Setting up SQL Anywhere as a consolidated database

Setting up the ODBC driver

Isolation level