SQL Anywhere provides two versions of the database server:
The personal database server This executable does not support client/server communications across a network. Although the personal database server is provided for single-user, same-computer use—for example, as an embedded database server—it is also useful for development work.
On Windows operating systems, except Windows CE, the name of the personal server executable is dbeng10.exe. On Unix operating systems its name is dbeng10. Only the network server is supported on Windows CE and NetWare.
The network database server Intended for multi-user use, this executable supports client/server communications across a network.
On Windows operating systems, including Windows CE, the name of the network server executable is dbsrv10.exe. On Novell NetWare the name is dbsrv10.nlm and on Linux and Unix operating systems it is dbsrv10.
The request-processing engine is identical in both the personal and network servers. Each one supports exactly the same SQL, and exactly the same database features. The main differences include:
Network protocol support Only the network server supports communications across a network.
Number of connections The personal server has a limit of ten simultaneous connections. The limit for the network server depends on your license. See Server Licensing utility (dblic).
Number of CPUs With per-seat licensing, the network database server uses all CPUs available on the computer (the default). With CPU-based licensing, the network database server uses only the number of processors you are licensed for. In addition, the personal database server and runtime database server are both limited to a single processor.
Startup defaults To reflect their use as a personal server and a network server for many users, the startup defaults are slightly different for each.
If you are running a SQL Anywhere network server, you must have appropriate networking software installed and running.
The SQL Anywhere network server is available for Windows, NetWare, Linux, and Unix operating systems.
SQL Anywhere supports the TCP/IP network protocol. The SPX protocol is also supported for Novell NetWare.
What else is there to it?