The sample database must be running on your Windows Mobile device before you can connect to it from Interactive SQL.
From the Start menu, tap Programs » SQLAny12.
In the Database field, type the path of the sample database. The default location is \My Documents\demo.db. Alternately, use Browse to locate the demo.db file.
In the Server Name field, type MobileServer.
In the Cache field, type 5MB.
The default cache size on Windows Mobile is 600 KB. However, a larger cache size is recommended because it can help improve performance.
In the Options field, type -x tcpip(port=2639).
The port that the database server will use is 2639. It is best to avoid the use of port 2638 which is also the default TCP/IP port for a SQL Anywhere server running on your desktop system. For more information, see -x dbeng12/dbsrv12 server option.
Select Use TCP/IP.
A TCP/IP connection is necessary to connect from a desktop computer to the database running on your Windows Mobile device.
Tap OK to start the sample database running on the network database server.
Navigate to the Today screen on your device.
Tap the database server icon located in the bottom right corner of the screen.
When the message Now accepting requests appears in the database server messages window, you can proceed to the next lesson.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|