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: Managing Windows CE databases with Interactive SQL

Tutorial: Managing Windows CE databases with Interactive SQL Next Page

Lesson 1: Start the sample database

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

To start the sample database
  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.

  4. In the Database field, type the path of the sample database. The default location is \Program Files\SQLAny10\demo.db. If you installed the software to a different location, use the Browse button to locate the database.

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

  6. Set the cache size by typing 5MB in the Cache field.

    The default cache size on Windows CE is 600 KB. However, a larger cache size is recommended to help improve performance.

  7. Select Use TCP/IP. This tutorial assumes that you will use the default proxy port number, 2638.

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

    The Server Messages window appears briefly, then disappears.

  9. Navigate to the Today screen on your device.

  10. Tap the 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 move on to the next lesson.

What's next?

Next you will learn how to connect from Interactive SQL to the database running on your Windows CE device.