Create an ODBC data source to connect to the Sybase Database on the 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.

For more information, see Use ODBC data sources.

This section 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

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.

On the [user DSN] tab, click [add].

The [create data source] dialog box appears.

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

The [ODBC configuration] dialog box is displayed.

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

For example, type cedevice.

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.

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

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.

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

In the adjacent field, type the connection parameter.

For example, type host = 127.0.0.1; dobroadcast = none; verifyservername = No.

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.

For more information, see edit registry.

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

For more information, see determine the IP address of the Windows CE device.

For more information, see use the TCP/IP protocol.

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.

For more information, see edit registry.

When dobroadcast = direct is specified, you do not need to broadcast the local subnet to search for the database server. However, the host IP address must be provided.

For more information, see determine the IP address of the Windows CE device.

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.

Edit registry:
1. Stop all Adaptive Server Anywhere Database servers running on desktop computers and Windows CE devices.

2. Remove the Windows CE device from its base.

3. Open the Registry Editor on the desktop computer.

4. type regedit at the command prompt.

5. In the Registry Editor, open the following HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows CE Services \ proxyports.

From the [edit] menu, choose [new]> [DWORD Value].

Enter the name ASA.

6. Double-click the ASA item you just created.

7. Specify the decimal value 2638 for it. (Please note that it must be decimal 2638)

This is the default TCP/IP Port value of Adaptive Server Anywhere.

Note:
Every time you install a Windows CE device on the base, ActiveSync forwards the communication on port 2638 to the device. Therefore, if you start a server on a desktop computer when installing a Windows CE device to the base, you cannot use the default port 2638. If this problem occurs, you can select another port to transfer Windows CE communication.

8. Click [OK].

9. Restart the PC.