Create an ODBC data source to connect to a Windows CE Device

The Open Database Connection (ODBC) interface is defined by Microsoft Corporation and is a standard interface used in Windows to connect client applications to the database management system. You can specify the connection parameters to connect. Typically, you can easily collect a set of connection parameters and store them in an ODBC data source. The ODBC data source is an easy way to save connection parameters for reuse.

This article describes how to create an ODBC Data Source on a Windows desktop computer to connect to a database running on a Windows CE device.

Create an ODBC data source to connect to a Windows CE Device

1. Open the ODBC manager on the desktop.

From the [start] menu, choose [Program] → [SQL Anywhere 9] → [Adaptive Server Anywhere] → [ODBC manager].

The ODBC manager is displayed.

2. on the [user DSN] tab, click [add].

The [create data source] dialog box appears.

3. Select [Adaptive Server Anywhere 9.0] and click [finish].

The [ODBC configuration] dialog box is displayed.

4. In the [data source name] Field on the [ODBC] tab, type the name of the data source.

For example, type CEdevice.

5. On the [logon] tab, select [provide user ID and password] and leave the [user ID] and [Password] fields blank.

Each time you connect to the database, you must provide the user ID and password.

Tip:

When connecting to the database, the default user ID is DBA. The default password is SQL.

6. On the [database] tab, leave the [server name] field blank.

Each time you connect from a desktop computer, you must specify the server name. This name

Appears in the title bar of the [Server Message] window of the Windows CE device.

7. On the [network] tab, select the [TCP/IP] check box.

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

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

Host: This parameter specifies the IP address that the Windows CE device listens.

If you must edit the Registry to connect to the Windows CE device, use the default IP address 127.0.0.1.

DoBroadcast

This parameter controls the TCP/IP connection mode.

If DoBroadcast = none is specified, the specified port is used for TCP/IP connection. Use this setting if you must edit the Registry to connect to your Windows CE device.

When DoBroadcast = direct is specified, you do not need to search for the database server.

Broadcast the local subnet. However, the host IP address must be provided.

9. Click [OK] to create the data source.

Now, you can use the data source you just created to connect to a database running on a Windows CE device from a desktop computer.

Related Articles]

• Use the code to refresh the ODBC link to the SQL Server table

• How to Use the ODBC function of Serv-U

• Install, configure, and program ODBC in Linux/Unix