Lesson 1: Start the database server

This section describes the simple case of running a single database on Windows Mobile.

 To start a database on the server
  1. From the Start menu, tap Programs » SQLAny12.

  2. Tap Server.

  3. In the Database field, type the name of the database file that you want to start or tap Browse and locate the Alpha.db file in the My Documents directory.

  4. In the Server Name field, type MobileServer.

  5. In the Options field, type -gd all -x tcpip(port=2639).

    The -gd option sets the permissions to allow any user to start additional databases on the network database server. This is necessary in a later lesson. See -gd dbeng12/dbsrv12 server option.

    The port that the database server will use is 2639. It is best to avoid the use of 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 dbeng12/dbsrv12 server option.

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

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

  8. Navigate to the Today screen on your device.

  9. 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?