Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere for Windows Mobile » Tutorial: Managing Windows Mobile databases with Interactive SQL

 

Lesson 1: Starting the sample database

Start the sample database on your Windows Mobile device so that you can connect to it from Interactive SQL.

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Managing Windows Mobile databases with Interactive SQL.

 Task

  1. On your Windows Mobile device, tap Start » Programs » SQLAny16.

  2. Tap Server.

    1. In the Database field, type the path of the sample database. The default location is \My Documents\demo.db. Alternately, use Browse to locate the demo.db file.

    2. In the Server Name field, type MobileServer.

    3. In the Cache field, type 5M.

      The default cache size on Windows Mobile is 600 KB. However, a larger cache size is recommended because it can help improve performance.

    4. In the Options field, type -x tcpip(port=2639).

      The port that the database server uses is 2639. It is best to avoid using port 2638 because it is the default TCP/IP port for a SQL Anywhere server running on your desktop system. For more information, see -x database server option.

    5. Click Use TCP/IP.

      A TCP/IP connection is necessary to connect from a desktop computer to the database running on your Windows Mobile device.

    6. Tap OK to start the sample database running on the network database server.

  3. Navigate to the Today screen on your device.

  4. Tap the database server icon located in the bottom right corner of the screen.

Results

The sample database is started on your Windows Mobile device.

Next

When the message Now accepting requests appears in the database server messages window, proceed to Lesson 2: Starting Interactive SQL and connecting.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0