Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere for Windows CE » Using the administration utilities on Windows CE » Tutorial: Running Windows CE databases from Sybase Central

Lesson 1: Starting the database server Next Page

Lesson 2: Starting multiple databases on the Windows CE database server

On Windows CE devices, attempting to start a second SQL Anywhere database server while a first database server is already running brings the first database server to the foreground. This is standard behavior for Windows CE applications. Because of this behavior, two database servers cannot be run at the same time on a Windows CE device. As an alternative to running multiple database servers, one server can run multiple databases.

To connect to a database from Sybase Central

  1. Start Sybase Central on your computer by choosing Start > Programs > SQL Anywhere 10 > Sybase Central.

    Sybase Central starts.

  2. From the Connections menu, choose Connect with SQL Anywhere 10.

    The Connect dialog appears.

  3. On the Identification tab, enter the following values:

  4. Select the ODBC Data Source Name option.

  5. Click Browse, choose the CEdevice data source that you created in Creating an ODBC data source to connect to your Windows CE device.

  6. On the Database tab, type the server name CEserver in the Server Name field.

  7. Click OK to connect to the Alpha.db database running on your Windows CE device.

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

To start a second database on the network database server

  1. From the Context dropdown list, choose CEserver.

  2. From the File menu, choose Start Database.

    The Start Database dialog appears.

  3. In the Database File field, type the following path: \My Documents\Beta.db

  4. Type the server name CEserver in the Server Name field.

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

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

To connect to the second database

  1. In the right pane of Sybase Central, select the Beta database icon.

    This icon represents the database that you just started on your Windows CE device.

  2. From the File menu, choose Connect.

    The Connect dialog appears.

  3. On the Identification tab, enter the following values:

  4. On the Database tab, type the database name \My Documents\Beta.db in the Database File field.

  5. Click OK to connect to the Beta database running on your Windows CE device.

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

What's next?

Next, you will learn how to disconnect from the databases and shut down the database server on Windows CE.