Administrator Guide : Managing network connections : Connect strings for ODBC clients
  
Connect strings for ODBC clients
The network name used by a client is a data source connect string. A connect string for clients that use the ODBC API consists of a communication protocol, a possible set of options, an optional host computer name, and a server name. By this combination, the client specifies the server it establishes the connection to. The connect string can also be mapped to logical data source name.
A default connect string can be defined with the client-side Com.Connect configuration parameter. The connect string can also be supplied, for example, at connection time or when configuring data sources with an ODBC driver manager.
The same format of the connect string applies to the Com.Connect parameter as well as to the connect string used by solidDB® tools or ODBC applications.
The format of a connect string is the following: protocol_name [options] [host_computer_name] server_name
where:
▪protocol_name must match the protocol that is used in the server network name, see Network listening names (Com.Listen).
▪host_computer_name is needed with TCP/IP and Named Pipes protocols, if the client and server are running on different machines.
▪server_name depends on the communication protocol:
– In TCP/IP protocol, server_name is a service port number, such as 2315.
– In other protocols, server_name is a name, such as solidDB or chicago_office.
For details on the syntax in different communication protocols, see Communication protocols.
▪options can be any combination of the following options:
Option
Description
Protocol
-4
Specifies that client connects using IPv4 protocol only.
TCP/IP or TLS
-6
Specifies that client connects using IPv6 protocol only.
In Windows environments, this option is mandatory if IPv6 protocol is used.
TCP/IP or TLS
-isource_address
Specifies an explicit connecting socket source address for cases where the system default source IP address binding does not meet application needs.
source_address can be an IP address or a host name.
TCP/IP or TLS
-z
Enables data compression for the connection
Notes
▪Data compression is not available for HotStandby connections (HotStandby.Connect) and NetBackup connections (ADMIN COMMAND 'netbackup').
▪Data compression for netcopy connections cannot be enabled with the -z option. Instead, use the HotStandby.NetcopyRpcCompress=yes parameter setting.
All
-c milliseconds
Specifies the login timeout (the default is operating-system-specific). A login request fails after the specified time has elapsed.
TCP/IP or TLS
-r milliseconds
Specifies the connection (or read) timeout. A network request fails when no response is received during the time specified. The value 0 (default) sets the timeout to infinite (operating system default timeout applies).
TCP/IP or TLS
-ofilename
Turns on the Network trace facility and defines the name of the trace output file. See “Network trace facility” in the solidDB® Administrator Guide for details.
All
-plevel
Pings the server at the given level (0-5).
Clients can always use the solidDB® Ping facility at level 1 (0 is no operation/default). Levels 2, 3, 4 or 5 may only be used if the server is set to use the Ping facility at least at the same level.
See “Ping facility” in the solidDB® Administrator Guide for details.
All
-t
Turns on the Network trace facility
See “Network trace facility” in the solidDB® Administrator Guide for details.
All
Notes
▪The protocol_name and the server_name must match the ones that the server is using in its network listening name.
▪If given at the connection time, the connect string must be enclosed in double quotation marks.
▪All components of the connect string are case insensitive.
Examples
[Com]
Connect=tcp -z -c1000 1315
[Com]
Connect=nmpipe host22 SOLID
solsql "tcp localhost 1315"
solsql "tcp 192.168.255.1 1315"
rc = SQLConnect(hdbc, "upipe SOLID", (SWORD)SQL_NTS, "dba", 3, "dba", 3);
rc = SQLDriverConnect(hdbc,
     (SQLHWND)NULL,
     (SQLCHAR*)"DSN=tcp localhost 1964;UID=dba;PWD=dba",
     38,
     out_string,
     255,
     &out_length,
     SQL_DRIVER_NOPROMPT);
See also
Default connect string (Com.Connect)
Logical data source names
OpenSSL for ODBC clients
Managing network connections