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 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere for Windows Mobile » Tutorial: Running Windows Mobile databases from Sybase Central

 

Lesson 4: Starting multiple databases

Now that you have started the database server and connected to the Alpha database, you can start additional databases on your Windows Mobile device.

Prérequis

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Creating Windows Mobile databases.

Contexte et remarques

When attempting to start a second SQL Anywhere database server on a Windows Mobile device, the standard behavior for Windows Mobile applications is to bring the first database server to the foreground. Because of this behavior, two database servers cannot run simultaneously on a Windows Mobile device. As an alternative to running multiple database servers, one database server can run multiple databases.

 Task

  1. In the left pane of Sybase Central, right-click MobileServer and click Start Database.

    1. In the Database File field, type \My Documents\Beta.db.

    2. Click OK to start the database on the network database server.

    The database is started on the network database server. Now you must initiate a connection from your desktop computer.

  2. In the left pane of Sybase Central, right-click Beta, and then click Connect.

  3. In the Connect window, complete the following fields:

    1. In the Authentication dropdown list, select Database.

    2. In the User ID field, type DBA.

    3. In the Password field, type sql.

    4. In the Action dropdown list, select Connect to a running database on another computer.

    5. In the Host field, type 169.254.2.1.

    6. In the Port field, type 2639.

    7. In the Server Name field, type MobileServer.

    8. In the Database Name field, type Beta.

  4. Click Connect to connect to Beta.db.

Résultat

You can now view and manipulate the data in the Alpha and Beta databases by using Sybase Central.

Once you connect to a database from Sybase Central, you can add data to the tables in your database, add and edit database objects, and perform other administrative tasks.

Suivant

Proceed to Lesson 5: Shutting down the database server on Windows Mobile.

Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0