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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Synchronizing with Microsoft Excel


Lesson 2: Setting up your MobiLink consolidated database

In this lesson, you create a database and define an ODBC data source.


This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up an Excel worksheet.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Synchronizing with Microsoft Excel.

Context and remarks

Your MobiLink consolidated database is a central repository of data and includes MobiLink system tables and stored procedures used to manage the synchronization process. With direct row handling, you synchronize with a data source other than a consolidated database, but you still need a consolidated database to maintain information used by the MobiLink server.


If you already have a MobiLink consolidated database set up with MobiLink system objects and a DSN, you can skip this lesson.

  1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Click Tools » SQL Anywhere 16 » Create Database.

  3. Click Next.

  4. Leave the default of Create a database on this computer, and then click Next.

  5. In the Save the main database file to the following file field, type the file name and path for the database. For example, c:\MLobjexcel\MLconsolidated.db.

  6. Follow the remaining instructions in the Create Database Wizard and accept the default values. If prompted to specify a user ID and password for the DBA user, enter DBA and sql, respectively.

    On the Connect To The Database page, clear the Stop the database after last disconnect option.

  7. Click Finish.

    The MLconsolidated database appears in Sybase Central.

  8. In Sybase Central, click Tools » SQL Anywhere 16 » Open ODBC Administrator.

  9. Click the User DSN tab, and then click Add.

  10. In the Create New Data Source window, click SQL Anywhere 16, and then click Finish.

  11. Perform the following tasks in the ODBC Configuration For SQL Anywhere window:

    1. Click the ODBC tab.

    2. In the Data source name field, type mlexcel_db.

    3. Click the Login tab.

    4. In the User ID field, type DBA.

    5. In the Password field, type sql.

    6. From the Action dropdown list, click Connect to a running database on this computer.

    7. In the Server name field, type MLconsolidated.

    8. Click OK.

  12. Close ODBC data source administrator.

    Click OK on the ODBC Data Source Administrator window.


A consolidated database and an ODBC data source for the consolidated database are created.

 See also