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 » Connecting to a database running on a Windows CE device

Creating proxy ports for Windows CE devices Next Page

Creating an ODBC data source to connect to your Windows CE device


This section describes how to create an ODBC data source on your Windows computer that connects to a database running on your Windows CE device.

For more information about ODBC data sources, see Working with ODBC data sources.

To create an ODBC data source to connect to your Windows CE device
  1. Open the ODBC Administrator on the computer.

    From the Start menu, choose Programs > SQL Anywhere 10 > SQL Anywhere > ODBC Administrator.

    The ODBC Administrator appears.

  2. On the User DSN tab, click Add.

    The Create New Data Source dialog appears.

  3. Select SQL Anywhere 10, and then click Finish.

    The ODBC Configuration dialog appears.

  4. On the ODBC tab, in the Data Source Name field, type a name for the data source.

    For example, type CEdevice.

  5. On the Login tab, select Supply User ID and Password. Make sure the User ID and Password fields blank.

    Each time you connect to a database, you must supply a user ID and password.

  6. On the Database tab, leave the Server Name field blank.

    Each time you connect from a computer, you must specify the server name. This name appears in the title bar of the Server Messages window on your Windows CE device.

  7. On the Network tab, select the TCP/IP checkbox.

  8. In the adjacent field, type the connection parameters.

    For example, type Host=127.0.0.1;Port=2638;DoBroadcast=none.

  9. Click OK to create the data source.

You can now use this data source to connect from a computer to a database running on your Windows CE device.

For more information, see Using the administration utilities on Windows CE.