SQL Anywhere database servers

SQL Anywhere provides two versions of the database server: the personal server (dbeng16) and the network server (dbsrv16). A database created with a personal database server can be used with a network database server and vice versa. The request-processing engine is identical in both the personal and network servers and each one supports exactly the same SQL language and many of the same database features. However, there are a few differences between the two servers.

The personal database server This executable is provided for single-user, same-computer use—for example, as an embedded database server—and does not support client/server communications across a network.
On Windows operating systems, except Windows Mobile, the name of the personal server executable is dbeng16.exe. On Unix operating systems its name is dbeng16. The personal server is not supported on Windows Mobile.
The network database server This executable supports client/server communications across a network, and is intended for multi-user use.
On Windows operating systems, including Windows Mobile, the name of the network server executable is dbsrv16.exe. On Linux and Unix operating systems, the name is dbsrv16.

Network software requirements

Differences between the network and personal servers
How to start the database server
How to stop the database server
Starting and stopping databases
Database server configuration
Maximum page size considerations
Database server names and database names
Configuration files and database server startup options
Database server action logging
How to suppress Windows event log messages
How to control performance and memory
Control privileges from the command line
Special modes
SQL Anywhere threading
How to run the database server as a service or daemon
Authenticated SQL Anywhere applications
SQL Anywhere on Windows Vista and later

Discuss this page in DocCommentXchange.