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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Running the Database Server » Some common options

Setting the database server's multiprogramming level Next Page

Selecting communications protocols

Any communication between a client application and a database server requires a communications protocol. SQL Anywhere supports a set of communications protocols for communications across networks and for same-computer communications.

By default, the database server starts all available protocols. You can limit the protocols available to a database server using the -x option. On the client side, many of the same options can be controlled using the CommLinks (LINKS) connection parameter.

For more information on running the server using these options, see Supported network protocols.

Available protocols for the personal server

The personal database server (dbeng10.exe) supports the following protocols:

Available protocols for the network server

The network database server (dbsrv10.exe) supports the following protocols:

Shared memory and terminal services

When using terminal services, shared memory clients can only find database servers running in the same terminal. If you use terminal services with a database server that is running as a service, only clients running on the console can connect. Clients running on non-console terminals cannot connect over shared memory. In these situations, you can use TCP/IP instead of shared memory to allow clients to connect.

For information about securing shared memory connections on Unix, see Security tips.

Specifying protocols

By using the -x option, you can instruct a database server to use only some of the available network protocols. The following command starts the sample database using the TCP/IP protocol:

dbsrv10 -x "tcpip" samples-dir\demo.db

Although not strictly required in this example, the quotes are necessary if there are spaces in any of the arguments to -x.

You can add additional parameters to tune the behavior of the server for each protocol. For example, the following command (typed all on one line) instructs the server to use two network cards, one with a specified port number.

dbsrv10 -x "tcpip(MyIP=," samples-dir\demo.db

For more information about available network protocol options that can be used with the -x option, see Network protocol options.