ASA Database Administration Guide
Connection Parameters and 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:
dbsrv9 -x tcpip(PARM1=value1;PARM2=value2;. . .),SPX
From the client side, you enter the protocol options as the CommLinks (LINKS) connection parameter:
CommLinks=tcpip(PARM1=value1;PARM2=value2;. . .),SPX
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:
dbsrv9 -x "tcpip(PARM1=value 1;PARM2=value 2;...),SPX" CommLinks="tcpip(PARM1=value 1;PARM2=value 2;...),SPX"
The quotation marks are 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, ON, TRUE, or 1, and are turned off with any of NO, OFF, FALSE, 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 @ server option to invoke the configuration file.
The options currently available for TCP/IP, HTTP, HTTPS, and SPX are as follows.
| TCP/IP | HTTP & HTTPS | SPX |
|---|---|---|
| Broadcast [BCAST] | Certificate | BroadcastListener [BLISTENER] |
| BroadcastListener [BLISTENER] | Certificate_Password | DLL |
| ClientPort [CPORT] | DatabaseName [DBN] | DoBroadcast [DOBROAD] |
| DLL | LocalOnly [LOCAL] | ExtendedName [ENAME] |
| DoBroadcast [DOBROAD] | LogFile [LOG] | Host [IP] |
| Host [IP] | LogMaxSize [LSize] | RegisterBindery [REGBIN] |
| LocalOnly [LOCAL] | LogOptions [LOpt] | SearchBindery [BINSEARCH] |
| LDAP [LDAP] | LogFormat [LF] | Timeout [TO] |
| MyIP [ME] | MaxConnections [MaxConn] | |
| ReceiveBufferSize [RCVBUFSZ] | MaxRequestSize [MaxSize] | |
| SendBufferSize [SNDBUFSZ] | MyIP [ME] | |
| ServerPort [PORT] | ServerPort [PORT] | |
| TDS | Timeout [TO] | |
| Timeout [TO] | ||
| VerifyServerName [VERIFY] |
Broadcast protocol option [BCAST]
BroadcastListener protocol option [BLISTENER]
Certificate protocol option
Certificate_Password protocol option
ClientPort protocol option [CPORT]
DatabaseName protocol option [DBN]
DLL protocol option
DoBroadcast protocol option [DOBROAD]
ExtendedName protocol option [ENAME]
Host protocol option [IP]
LDAP protocol option [LDAP]
LocalOnly protocol option [LOCAL]
LogFile protocol option [LOG]
LogFormat protocol option [LF]
LogMaxSize protocol option [LSIZE]
LogOptions protocol option [LOPT]
MaxConnections protocol option [MAXCONN]
MaxRequestSize protocol option [MAXSIZE]
MyIP protocol option [ME]
ReceiveBufferSize protocol option [RCVBUFSZ]
RegisterBindery protocol option [REGBIN]
SearchBindery protocol option [BINSEARCH]
SendBufferSize protocol option [SNDBUFSZ]
ServerPort protocol option [PORT]
TDS protocol option
Timeout protocol option [TO]
VerifyServerName protocol option [VERIFY]
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.