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: Managing Windows CE databases with Interactive SQL

Lesson 1: Start the sample database Next Page

Lesson 2: Start Interactive SQL and connect

Now that the sample database is running on your Windows CE device, connect to it from Interactive SQL to view and manage the database from your computer.

To connect from Interactive SQL to a database on your Windows CE device
  1. Start Interactive SQL on your computer by choosing Start > Programs > SQL Anywhere 10 > Interactive SQL.

    The Connect dialog appears automatically when Interactive SQL starts.

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

  3. Select the ODBC Data Source Name option.

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

    Click OK.

  5. On the Database tab, specify the server name in the Server Name field.

    In this example, the server name is CEserver, which you specified in the previous lesson.

  6. Click OK to connect to the sample database running on your Windows CE device.

What's next?

You can now view and manage the data in the sample database from Interactive SQL.