Network protocol options (for both the client and the server) enable you to work around peculiarities of different network protocol implementations.
| Server side | Client side | ||||
|---|---|---|---|---|---|
|
You can supply the network protocol options in the server command. For example:
|
NoteNote In most cases, you should use the Host connection parameter. See Host connection parameter. You should only use the CommLinks (LINKS) connection parameter if you need to specify TCP/IP options other than Host or ServerPort (PORT). You cannot specify both CommLinks and Host in the connection string. From the client side, you enter the protocol options as the CommLinks (LINKS) connection parameter:
NoteIf you are connecting to a database server on the same computer as the client, then shared memory is recommended. See Communication protocol considerations. |
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.
You can also include the protocol options in a configuration file and use the @data server option to invoke the configuration file.
Broadcast (BCAST) protocol option
BroadcastListener (BLISTENER) protocol option (server side only)
certificate_company protocol option
certificate_name protocol option
certificate_unit protocol option
ClientPort (CPORT) protocol option (client side only)
DatabaseName (DBN) protocol option
DoBroadcast (DOBROAD) protocol option
Host (IP) protocol option (client side only)
Identity protocol option
Identity_Password protocol option
FIPS protocol option
KeepaliveTimeout (KTO) protocol option
LDAP protocol option
LocalOnly (LO) protocol option
LogFile (LOG) protocol option
LogFormat (LF) protocol 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 (server side only)
Timeout (TO) protocol option
trusted_certificate protocol option
VerifyServerName (VERIFY) protocol option (client side only)
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |