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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections

Network protocol options

Network protocol options enable you to work around traits of different network protocol implementations.

Server side Client side

For the database server, specify network communication protocol options by using the -x tcpip option. For example:

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

For the database server, specify network transport layer security encryption protocol options by using the -ec tls option. For example:

dbsrv17 -ec tls(PARM1=value1;PARM2=value2;...)

For the database server, specify web server protocol options by using the -xs http, -xs https, or -xs odata option. For example:

dbsrv17 -xs http(PARM1=value1;PARM2=value2;...)

For client applications, you specify network protocol options using the CommLinks (LINKS) connection parameter:

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

For client applications, you specify transport layer security encryption options using the Encryption (ENC) connection parameter:

Encryption=tls(PARM1=value1;PARM2=value2;...)

If there are spaces in an option value, then enclose network protocol options in quotation marks so that they are parsed properly by the system command interpreter. For example:

dbisql -c "host=localhost;server=demo;encryption=tls(fips=yes;certificate_name=RSA Server;certificate_company=SAP;certificate_unit=SQL Anywhere;trusted_certificates=rsaroot.crt)"

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

Boolean options are turned on with YES, Y, ON, TRUE, T, or 1, and are turned off with any of NO, N, OFF, FALSE, F, or 0. The protocol option names are case insensitive. For example:

dbisql -c "Host=localhost;Server=demo;Encryption=TLS(FIPS=1;Certificate_Name=RSA Server;Certificate_Company=SAP;Certificate_Unit=SQL Anywhere;Trusted_Certificates=rsaroot.crt)"

You can also include the protocol options in a configuration file and use the @data server option to invoke the configuration file.

Note

Use the Host connection parameter instead of the CommLinks (LINKS) connection parameter. 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 a connection string.

When you use the CommLinks (LINKS) connection parameter for a TCP/IP connection, specify a server name by using the ServerName (Server) connection parameter.

If you are connecting to a database server on the same computer as the client, then shared memory is recommended.

TCPIP HTTP HTTPS TLS OData
Broadcast (BCAST) protocol option DatabaseName (DBN) protocol option DatabaseName (DBN) protocol option certificate_company protocol option (client side only) ExitOnError (EXIT) protocol option
BroadcastListener (BLISTENER) protocol option (server side only) KeepaliveTimeout (KTO) protocol option FIPS protocol option certificate_name protocol option (client side only) LogFile (LOG) protocol option
ClientPort (CPORT) protocol option (client side only) LocalOnly (LO) protocol option Identity protocol option certificate_unit protocol option (client side only) LogVerbosity protocol option
DoBroadcast (DOBROAD) protocol option LogFile (LOG) protocol option Identity_Password protocol option FIPS protocol option MyIP protocol option
Host (IP) protocol option (client side only) LogFormat (LF) protocol option KeepaliveTimeout (KTO) protocol option Identity protocol option (server side only) QuietConsole (QUIET) protocol option
LDAP protocol option LogMaxSize (LSIZE) protocol option LocalOnly (LO) protocol option Identity_Password protocol option (server side only) SecureMyIP protocol option
LocalOnly (LO) protocol option LogOptions (LOPT) protocol option LogFile (LOG) protocol option trusted_certificates protocol option (client side only) SecureServerPort protocol option
MyIP (ME) protocol option LogRename (LRENAME) protocol option LogFormat (LF) protocol option skip_certificate_name_check option (client side only) ServerPort (PORT) protocol option
ReceiveBufferSize (RCVBUFSZ) protocol option MaxConnections (MAXCONN) protocol option LogMaxSize (LSIZE) protocol option allow_expired_certs option SSLKeyStore (KEYSTORE) protocol option
SendBufferSize (SNDBUFSZ) protocol option MaxRequestSize (MAXSIZE) protocol option LogOptions (LOPT) protocol option   SSLKeyStorePassword (KEYSTOREPASSWORD) protocol option
ServerPort (PORT) protocol option MaxRequestVars (MAXVARS) protocol option MaxConnections (MAXCONN) protocol option    
TDS protocol option (server side only) MyIP (ME) protocol option MaxRequestSize (MAXSIZE) protocol option    
Timeout (TO) protocol option ServerPort (PORT) protocol option MaxRequestVars (MAXVARS) protocol option    
VerifyServerName (VERIFY) protocol option (client side only) Timeout (TO) protocol option MyIP (ME) protocol option    
    ServerPort (PORT) protocol option    
    Timeout (TO) protocol option    

allow_expired_certs option