Lesson 1: Start the sample database

The sample database must be running on your Windows Mobile device before you can connect to it from Interactive SQL.

 To start the sample database
  1. From the Start menu, tap Programs » SQLAny12.

  2. Tap Server.

  3. 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.

  4. In the Server Name field, type MobileServer.

  5. In the Cache field, type 5MB.

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

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

    The port that the database server will use is 2639. It is best to avoid the use of port 2638 which is also the default TCP/IP port for a SQL Anywhere server running on your desktop system. For more information, see -x dbeng12/dbsrv12 server option.

  7. Select Use TCP/IP.

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

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

  9. Navigate to the Today screen on your device.

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

    When the message Now accepting requests appears in the database server messages window, you can proceed to the next lesson.

 What's next?