On Windows Mobile devices, attempting to start a second SQL Anywhere database server while a first database server is already running brings the first database server to the foreground. This is standard behavior for Windows Mobile applications. Because of this behavior, two database servers cannot run at the same time on a Windows Mobile device. As an alternative to running multiple database servers, one server can run multiple databases.
Choose Start » Programs » SQL Anywhere 11 » Sybase Central.
Choose Connections » Connect With SQL Anywhere 11.
Click the Identification tab and complete the following fields:
User ID DBA
Click ODBC Data Source Name.
Click Browse, choose the MobileServer data source that you created in Create an ODBC data source to connect to your Windows Mobile device.
Click the Database tab and type MobileServer in the Server Name field.
Click OK to connect to the Alpha.db database running on your Windows Mobile device.
If you fail to connect to the database server:
Now that you have started the database server and connected to the Alpha database, you can start additional databases on your Windows Mobile device.
In the left pane of Sybase Central, right-click MobileServer and choose Start Database.
In the Database File field, type \My Documents\Beta.db.
Click OK to start the database on the network database server.
The database is loaded on the network database server. Now you must initiate a connection from your computer.
In Sybase Central, choose File » Connect.
Click the Identification tab, and complete the following fields:
User ID DBA
Click the Database tab and complete the following fields:
Database File Beta
Server Name MobileServer
Click OK to connect to the Beta database running on your Windows Mobile device.
You can now view and manipulate the data in the Alpha and Beta databases using Sybase Central.
Next, you will learn how to disconnect from the databases and shut down the database server on Windows Mobile.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|