Lesson 2: Start Interactive SQL and connect

Now that the sample database is running on your Windows Mobile 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 Mobile device

  1. Choose Start » Programs » SQL Anywhere 11 » Interactive SQL.

  2. Click the Identification tab and complete the following fields:

    • User ID   Type DBA.

    • Password   Type sql.

  3. Select ODBC Data Source Name.

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

  5. Click OK.

  6. Click the Database tab and type MobileServer in the Server Name field. If you fail to connect to the server:

    • Click the Network tab.
    • Click TCP/IP.
    • Complete the Host and Port(s) fields.
    • Click OK.

  7. Click OK to connect to the sample database running on your Windows Mobile device.

What's next?

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

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0