Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere for Windows CE » Using the administration utilities on Windows CE » Tutorial: Running Windows CE databases from Sybase Central

Tutorial: Running Windows CE databases from Sybase Central Next Page

Lesson 1: Starting the database server

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

To start a database on the server

  1. Open File Explorer on your Windows CE device by tapping Start > Programs > File Explorer.

  2. Navigate to the SQL Anywhere installation directory by tapping Program Files > SQLAny10.

  3. Tap the dbsrv10 icon.

    The Server Startup Options dialog appears.

    Server Startup Options dialog

  4. Specify the database file that you want to start.

    Tap Browse and locate the Alpha.db file in the My Documents directory.

  5. Assign a name to the network database server by typing CEserver in the Server Name field.

  6. Use the default cache size of 600 KB.

    Tip

    For the purposes of this tutorial, the default cache size is sufficient. However, a larger cache size can help improve performance for larger databases. See Use the cache to improve performance.

  7. Select the Use TCP/IP option.

    A TCP/IP connection is necessary to connect from a computer to the database running on your Windows CE device. You will connect from your computer in a later lesson.

  8. In the Options field of the Server Startup Options dialog, type -gd all.

    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 server option.

  9. Tap OK to start the Alpha database running on the network database server.

  10. Navigate to the Today screen on your device.

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

    The Server Messages window appears.

When the message Now accepting requests appears in the Server Messages window, you are ready to proceed to the next lesson.

What's next?

Next, you will learn how to start multiple databases on the network database server on Windows CE.