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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere database servers


Differences between the network and personal servers

The following table lists common database server features and how they differ between personal database servers and network database servers.

Feature Network database server (dbsrv16) Personal database server (dbeng16)
Checkpoints The CHECKPOINT system privilege is required to use the CHECKPOINT statement. No system privileges are required to use the CHECKPOINT statement.
Communication packet compression Supported. Unsupported.
Connecting to the utility database By default, no connections are allowed to the utility database. You must use the -su option to specify the password for connecting to the utility database. See -su database server option. By default, connections to the utility database are allowed with the user ID DBA and any password.
Connection types Shared memory and TCP/IP by default. Shared memory by default. To connect with the TCP/IP protocol use the -x option. See -x database server option.
Database mirroring Supported. See Database mirroring. Unsupported.
LDAP as a name server Can only be used with TCP/IP. See Connections using LDAP as a name server. Unsupported. Do not confuse this with LDAP user authentication which is supported.
Multiprogramming level tuning Supported. See Database server configuration of the multiprogramming level. Unsupported.
Network communications Supported. Unsupported.
Number of connections Limited by license. See Editions and licensing. Maximum of ten simultaneous connections.
Number of CPUs Limited by license. Maximum of four cores on one CPU.
Read-only scale-out Supported. See SQL Anywhere read-only scale-out. Unsupported.
Windows Mobile Supported. See SQL Anywhere for Windows Mobile. Unsupported.
 Server and database options
 Database server properties