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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Starting and connecting to your database

 

Network protocol options

Network protocol options (for both the client and the server) enable you to work around peculiarities of different network protocol implementations.

You can supply the network protocol options in the server command. For example:

dbsrv12 -x tcpip(PARM1=value1;PARM2=value2;...)

From the client side, you enter the protocol options as the CommLinks (LINKS) connection parameter:

CommLinks=tcpip(PARM1=value1;PARM2=value2;...)

If there are spaces in a parameter, the network protocol options must be enclosed in quotation marks to be parsed properly by the system command interpreter:

dbsrv12 -x "tcpip(PARM1=value1;PARM2=value2;...)"
CommLinks="tcpip(PARM1=value1;PARM2=value2;...)"

The quotation marks are also required under Unix if more than one parameter is given because Unix interprets the semicolon as a command separator.

Boolean parameters are turned on with YES, Y, ON, TRUE, T, or 1, and are turned off with any of NO, N, OFF, FALSE, F, and 0. The parameters are case insensitive.

The examples provided should all be entered on a single line; you can also include them in a configuration file and use the @data server option to invoke the configuration file.

TCP/IP HTTP HTTPS TLS
Broadcast (BCAST) protocol option DatabaseName (DBN) protocol option certificate_company protocol option certificate_company protocol option
BroadcastListener (BLISTENER) protocol option KeepaliveTimeout (KTO) protocol option certificate_name protocol option certificate_name protocol option
ClientPort (CPORT) protocol option LocalOnly (LOCAL) protocol option certificate_unit protocol option certificate_unit protocol option
DoBroadcast (DOBROAD) protocol option LogFile (LOG) protocol option DatabaseName (DBN) protocol option FIPS protocol option
Host (IP) protocol option LogFormat protocol (LF) option Identity protocol option LocalOnly (LOCAL) protocol option
LDAP protocol option LogMaxSize (LSIZE) protocol option Identity_Password protocol option trusted_certificates protocol option
LocalOnly (LOCAL) protocol option LogOptions (LOPT) protocol option FIPS protocol option
MyIP (ME) protocol option MaxConnections (MAXCONN) protocol option LocalOnly (LOCAL) protocol option
ReceiveBufferSize (RCVBUFSZ) protocol option MaxRequestSize (MAXSIZE) protocol option LogFile (LOG) protocol option
SendBufferSize (SNDBUFSZ) protocol option MyIP (ME) protocol option LogFormat protocol (LF) option
ServerPort (PORT) protocol option ServerPort (PORT) protocol option LogMaxSize (LSIZE) protocol option
TDS protocol option Timeout (TO) protocol option LogOptions (LOPT) protocol option
Timeout (TO) protocol option MaxConnections (MAXCONN) protocol option
VerifyServerName (VERIFY) protocol option MaxRequestSize (MAXSIZE) protocol option
MyIP (ME) protocol option
ServerPort (PORT) protocol option
Timeout (TO) protocol option
trusted_certificates protocol option

Broadcast (BCAST) protocol option
BroadcastListener (BLISTENER) protocol option
certificate_company protocol option
certificate_name protocol option
certificate_unit protocol option
ClientPort (CPORT) protocol option
DatabaseName (DBN) protocol option
DoBroadcast (DOBROAD) protocol option
Host (IP) protocol option
Identity protocol option
Identity_Password protocol option
FIPS protocol option
KeepaliveTimeout (KTO) protocol option
LDAP protocol option
LocalOnly (LOCAL) protocol option
LogFile (LOG) protocol option
LogFormat protocol (LF) option
LogMaxSize (LSIZE) protocol option
LogOptions (LOPT) protocol option
MaxConnections (MAXCONN) protocol option
MaxRequestSize (MAXSIZE) protocol option
MyIP (ME) protocol option
ReceiveBufferSize (RCVBUFSZ) protocol option
SendBufferSize (SNDBUFSZ) protocol option
ServerPort (PORT) protocol option
TDS protocol option
Timeout (TO) protocol option
trusted_certificates protocol option
VerifyServerName (VERIFY) protocol option