Collection Contents Index CommBufferSize connection parameter [CBSIZE] Next PDF

SQL Anywhere® Server - Database Administration  > Connection Parameters and Network Protocol Options  > Connection parameters

CommLinks connection parameter [LINKS]


Specifies client-side network protocol options.

Usage

Anywhere. The CommLinks (LINKS) connection parameter is optional for connections to a personal server, and required for connections to a network server.

Values

String

Default

Use only the shared memory communication protocol to connect.

Remarks

If you do not specify a CommLinks (LINKS) connection parameter, the client searches for a server on the current computer only, and only using a shared memory connection. This is the default behavior, and is equivalent to CommLinks=ShMem. The shared memory protocol is the fastest communication link between a client and server running on the same computer, as is typical for applications connecting to a personal database server.

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

If you specify CommLinks=ALL, the client searches for a server using all available communication protocols. Since there may be an impact on performance if you specify CommLinks=ALL, use this setting only when you don't know which protocol to use.

If you specify one or more protocols in the CommLinks (LINKS) connection parameter, the client uses the named communication protocol(s), in the order specified, to search for a network database server. Note that if shared memory is specified, an attempt to connect using shared memory is made first, and then the remaining communication protocols are tried in the order in which they are specified. A connection error appears and the connection attempt aborts if the connection fails to connect using a specified protocol, even if there are protocols remaining in the list to try.

CommLinks (LINKS) connection parameter values are case insensitive, and include:

Each of these values can have additional network protocol options supplied.

See Network protocol options.

You may want to use a specific protocol, as opposed to ALL, for the following reasons:

The CommLinks (LINKS) connection parameter corresponds to the database server -x option.

See also
Examples

The following connection string fragment starts the TCP/IP protocol only:

CommLinks=tcpip

The following connection string fragment starts the shared memory protocol and searches for the database server over shared memory. If the search fails, it then starts the TCP/IP link and searches for the server on the local network. If that fails, it starts the SPX link and searches for the server over SPX.

CommLinks=tcpip,shmem,spx

The following connection string fragment starts the SPX port and searches for the server over SPX. If the search fails, it then starts the TCP link and searches for the server on the local network, as well as the host kangaroo. Note that if the server is found over SPX, the TCP link is not started.

CommLinks=spx,tcpip(HOST=kangaroo)

Collection Contents Index CommBufferSize connection parameter [CBSIZE] Next PDF