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

This section describes how to create an ODBC data source on your Windows computer that connects to a database running on your Windows Mobile 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 Mobile device

  1. From the Start menu, choose Programs » SQL Anywhere 11 » ODBC Administrator.

  2. On the User DSN tab, click Add.

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

  4. On the ODBC tab, in the Data Source Name field, type MobileServer.

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

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

  6. Click the Network tab, select TCP/IP and type the connection parameters.

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

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

      If you connected a Windows Mobile device using a USB connection, use the default IP address of 169.254.2.1.

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

    • Port   specifies the port number that the Windows Mobile device listens on. This parameter is optional.

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

    • 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 Mobile device.

      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].

  7. Click OK.

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

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