Lesson 2: Setting up your MobiLink consolidated database

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up a text file data source.

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.

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

Note

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

 Set up your MobiLink consolidated database

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

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

  3. Click Next.

  4. Accept the default value Create Database On This Computer and 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:\MLdirect\MLconsolidated.db.

  6. Follow the remaining instructions in the Create Database Wizard and accept the default values. 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. Click Close on the Creating Database window.

  9. Use the SQL Anywhere 12 driver to define an ODBC data source for the MLconsolidated database.

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

  10. Click the User DSN tab and click Add.

  11. In the Create New Data Source window, click SQL Anywhere 12 and click Finish.

  12. 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 mldirect_db.

    3. Click the Login tab.

    4. In the User ID field, type DBA.

    5. In the Password field, type sql.

    6. In the Server Name field, type MLconsolidated.

    7. Click OK.

  13. Close the ODBC Data Source Administrator.

    Click OK on the ODBC Data Source Administrator window.

  14. Proceed to Lesson 3: Creating a table in your MobiLink consolidated database.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1