Contents Index Controlling threading behavior Stopping the database server

ASA Database Administration Guide
  Running the Database Server
    Some common options

Selecting communications protocols


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

By default, the database server starts up 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 (dbeng9.exe) supports the following protocols:

Available protocols for the network server 

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

Specifying protocols 

You can instruct a server to use only some of the available network protocols when starting up, using the -x option. The following command starts the asademo database using the TCP/IP and SPX protocols:

dbsrv9 -x "tcpip,spx" path\asademo.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.

dbsrv9 -x "tcpip{MyIP=192.75.209.12:2367,192.75.209.32}" path\asademo.db

For more information about available network communications parameters that can serve as part of the -x option, see Network communications parameters.


Contents Index Controlling threading behavior Stopping the database server