solidDB Help : solidDB reference : ODBC: Connection string syntax
  
ODBC: Connection string syntax
The network name that is used by a client is called a data source connect string, see Connect strings for ODBC clients.
An ODBC connect string has the following format.
If given at connection time, the connect string must be enclosed in double quotation marks. Components of the connect string are not case-sensitive.
[grid] protocol_name [options] [host_computer_name] server_name
where:
▪ grid is included when you are connecting to a grid node, see Connecting to a grid.
▪ 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 and must match the server name that is used in the server network name:
– 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
-i source_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
-o filename
Turns on the Network trace facility and defines the name of the trace output file.
See Network trace facility for details.
All
-p level
Pings the server at the given level (0-5).
Clients can always use the solidDB Ping facility at level 1 (the default value, 0 means no operation). Levels 2, 3, 4, or 5 can be used only if the server is set to use the Ping facility at least at the same level.
See Ping facility for details.
All
-t
Turns on the Network trace facility
See Network trace facility for details.
All