Lesson 2: Starting Interactive SQL and connecting

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.

 Connect from Interactive SQL to a database on your Windows Mobile device

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

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

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

  3. From the Action dropdown list, click 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 Demo.

  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 Creating an ODBC data source to connect to your Windows Mobile device.

  5. Proceed to Lesson 3: Executing queries against a Windows Mobile database.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1