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

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.

   • Host    specifies the IP address that the Windows CE device listens on.

     If you created a proxy port to connect to your Windows CE device, use the default IP address of 127.0.0.1 (this is the default localhost address).

     For more information, see Creating proxy ports for Windows CE devices.

     Otherwise, use the IP address of your Windows CE device.

     For more information, see Starting a server on your Windows CE device.

   • Port    specifies the port number that the Windows CE device listens on. This parameter is optional. It must be specified when the default proxy port number is not used.

     The proxy port number that is assumed when not specified is 2638.

     For more information, see Creating proxy ports for Windows CE devices.

   • DoBroadcast    controls how the TCP/IP connection is made. This parameter is optional.

     When DoBroadcast=none is specified, the TCP/IP connection is made directly with the port specified. Use this setting if you created a proxy port to connect to your Windows CE device.

     For more information, see Creating proxy ports for Windows CE devices.

     When DoBroadcast=direct is specified, no broadcast is performed to the local subnet to search for a database server. Instead, the Host IP address is required.

     For more information, see DoBroadcast protocol option [DOBROAD].

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.