ASA Database Administration Guide
Running the Database Server
Starting the server
The database server supplied for Windows CE is the network database server (dbsrv9.exe). The network server supports communications over a TCP/IP network link.
The usual client/server arrangement has the database server running on a machine with more power and resources than the client applications. Clearly, this is not the case with Windows CE; instead, the less powerful machine is running the database server.
The advantage to supplying a network server on Windows CE is that you can run database applications on your desktop computer to carry out tasks on your Windows CE database. For example:
You can use Sybase Central on your desktop PC to manage your database.
You can use Interactive SQL on your desktop to load and unload data, and carry out queries.
You can use InfoMaker to produce reports.
The Windows CE database server does not start the TCP/IP network link unless it is explicitly requested:
dbsrv9 -x tcpip ...
On Pocket PCs, attempting to start a second Adaptive Server Anywhere server while a first server is already running brings the first server to the foreground. This is standard behavior for Pocket PC applications. Because of this, two servers cannot be run at the same time on a Pocket PC. As an alternative to multiple servers, one server can run more than one database if necessary. Note that -ga all
is required to autostart a database on a running server.