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: Introducing MobiLink

 

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.

Prerequisites

There are no prerequisites for this task.

 Task
  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 click Next.

  5. In the Save the main database file to the following file field, type c:\MLintro\MLconsolidated.db. Click Next. If the directory does not exist, you are asked to create it. Click Yes.

  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, check the Stop database after last disconnect option.

  7. Click Finish.

    The MLconsolidated database is created.

  8. In the Creating Database window, click Close if the window did not close automatically.

  9. Click Connections » Disconnect to stop the personal database server.

  10. Click Tools » SQL Anywhere 16 » Open ODBC Administrator.

  11. Click the User DSN tab, and click Add.

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

  13. 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 Start and connect to a database on this computer.

    8. In the Database file field, type c:\MLintro\MLconsolidated.db.

    9. In the Server name field, type MLconsolidated.

    10. In the Start line field type dbsrv16.

    11. Click the ODBC tab and click the Test Connection button to verify that the connection is successful. Click OK.

    12. Click OK and then click OK again to close the ODBC Data Source Administrator window.

  14. Click Connections » Connect with SQL Anywhere 16.

  15. In the Action dropdown list, select Connect with an ODBC data source.

  16. In the ODBC Data Source Name field, type mlintro_consdb.

  17. Click Connect.

Results

A SQL Anywhere consolidated database and an ODBC data source are created.

 See also