Collection Contents Index Connecting to a database running on a Windows CE device Next PDF

SQL Anywhere® Server - Database Administration  > SQL Anywhere for Windows CE  > Connecting to a database running on a Windows CE device

Starting a server on your Windows CE device


If you wish to connect from your desktop computer to a database server that is running on Windows CE, you must select the TCP/IP option when starting the server.

If you have an ActiveSync connection via USB, such as when the device is cradled, you must set up a proxy port to be able to connect to the Windows CE database server.

To start the database server on your Windows CE device for a remote connection
  1. Open File Explorer on your Windows CE device.

    From the Start menu, tap 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.

    Use the Browse button to locate the database.

  5. Specify the server name that you want to use.

    For example, type CEserver in the Server Name field of the Server Startup Options dialog.

  6. Select Use TCP/IP.

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

  7. If you wish to use a proxy port number other than the default of 2638, specify the proxy port number using the -x tcpip option. For example, if the proxy port number is 2639, then type -x tcpip{port=2639} in the Options field of the Server Startup Options dialog.

    Note that when the -x tcpip option is used, selecting the Use TCP/IP option is redundant.

    For more information, see -x server option.

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

Now you can create a proxy port and an ODBC data source to connect from the computer to your Windows CE device.

See also

Collection Contents Index Connecting to a database running on a Windows CE device Next PDF