Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » SQL Anywhere for Windows Mobile » SQL Anywhere for Windows Mobile » Using the administration utilities on Windows Mobile » Tutorial: Managing Windows Mobile databases with Interactive SQL


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.