Lesson 1: Setting up a MobiLink consolidated database

In this lesson, you set up a SQL Anywhere consolidated database by creating it and defining an ODBC data source.

 Set up your 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. Leave the default of Create A 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:\MLintro\MLconsolidated.db. Click Next.

  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 Database After Last Disconnect option.

  7. Click Finish.

    The MLconsolidated database is created.

  8. In the Creating Database window, click Close.

  9. 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 mlintro_consdb.

    3. Click the Login tab.

    4. In the Authentication dropdown list, leave the default of Database to connect using your user ID and password.

    5. In the User ID field, type DBA.

    6. In the Password field, type sql.

    7. In the Action dropdown list, leave the default of Connect To A Running Database On This Computer.

    8. In the Server Name field, type MLconsolidated.

    9. Click OK.

  13. Click OK to close the ODBC Data Source Administrator window.

  14. Proceed to Lesson 2: Creating and populating a table in the MobiLink consolidated database.

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