On the Windows desktop computer, click Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.
On the User DSN tab, click Add.
Click SQL Anywhere 12, and then click Finish.
On the ODBC tab, in the Data Source Name field, type MobileServer.
Click the Login tab.
Authentication Click Database.
User ID Make sure this field is blank. Each time you connect to a database, you must supply a user ID and password.
Password Make sure this field is blank. The Encrypt Password box should be cleared.
Action Click Connect To A Running Database On Another Computer.
Host If you connected a Windows Mobile 5.0 or 6.0 device using Windows Mobile Device Center (ActiveSync) over a USB connection, try the Windows Mobile device IP address 169.254.2.1.
For some Windows Mobile devices, especially older devices, you might encounter difficulty using this address. If so, try the localhost (127.0.0.1) IP address. In this case you must also have set up a proxy port. For information about setting up a proxy port, see Proxy ports for Windows Mobile devices.
For more information, see Determining the IP address of your Windows Mobile device.
Port Specify the port number that the Windows Mobile device listens on.
Use the port that the database server on the Windows Mobile device is configured to use when it is started. It is recommended that you use port 2639. See Starting a database server on your Windows Mobile device.
Server Name Fill in the server name if you wish to connect to a specific database server running on the Windows Mobile device. Otherwise, make sure this field is blank.
Database Name Fill in the database name if you wish to connect to a specific database running on the Windows Mobile device. Otherwise, make sure this field is blank.
You can now use this data source to connect from a Windows desktop computer to a database running on your Windows Mobile device.
To test the connection, you can use the dbping utility. If a database has been started on the Windows Mobile device, then use a command like the following to test the connection.
dbping -c "DSN=MobileServer;UID=DBA;PWD=sql"
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|