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 desktop computer.

 To connect from Interactive SQL to a database on your Windows Mobile device

  1. On the desktop computer, choose Start » Programs » SQL Anywhere 12 » Administration Tools » Interactive SQL.

  2. In the Authentication dropdown list, choose Database then:

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

  3. From the Action dropdown list, choose Connect To A Running Database On Another Computer.

    1. In the Host field, type 169.254.2.1.

    2. In the Port field, type 2639.

    3. In the Server Name field, type MobileServer.

    4. In the Database Name field, type Beta.

  4. Click Connect to connect to the sample database running on your Windows Mobile device.

    If you fail to connect to the database server, see Create an ODBC data source to connect to your Windows Mobile device.

 What's next?
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0