Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server

 

Introduction to running SQL Anywhere database servers

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.

Server differences

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.

Network software requirements

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.


First steps
What else is there to it?
Running SQL Anywhere on Windows Vista