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 Mobile, the name of the personal server executable is dbeng11.exe. On Unix operating systems its name is dbeng11. Only the network server is 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 dbsrv11.exe. On Linux and Unix operating systems, the name is dbsrv11.
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. A database created with a personal database server can be used with a network database server and vice versa. 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. The number of CPUs that the network database server can use may also be affected by your SQL Anywhere edition or the -gt server option. The personal database server is limited to a single processor. See:
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, Linux, and Unix operating systems.
SQL Anywhere supports the TCP/IP network protocol.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|