UID is automatically removed from the connectionĭuring a query the server sends feedback to the client at set intervals. Schema that is opened directly after the connection. PWD is automatically removed from the connection string The log file can possibly contain sensitive data (SQL commands and data).This is not recommended in productive environment. Depending on the log mode, the size of the log file can be huge.For example:ĮXAHOST=/NOCERTCHECK:8563ĮXAHOST=:8563/nocertcheckĮXAHOST=:8563 FINGERPRINT=NoCertCheck To disable TLS encryption you can use the NOCERTCHECK option. The two slashes ("//") indicate that a file path is specified. You can also specify the path to a file that contains a host list, for example, //c:\mycluster.txt. If host names are specified in the list they can have DNS entries with multiple IP addresses. Instead of an IP range you can define a comma-separated list of host:port pairs.
#DATAGRIP CONNECT TO DATABASE BY PEM KEY DRIVER#
If the connection fails, the driver will continue to try all other possible addresses. When opening a connection, the driver will randomly choose an address from the specified address range. Sets ANSIARGENCODING, ANSIDATAENCODING, UNICODEARGENCODING, and UNICODEDATAENCODING to the given value. Valid values for this option are "1" (UTF-16) or "2" (UTF-8). If the client uses the DataDirect driver manager, this parameter specifies the type of Unicode to be used in W-functions. Here are some examples:ĭefault size for VARCHAR parameters in prepared statements whose type Sets LC_NUMERIC to the given value during the connection. You can also set an encoding, for example, en_US.UTF. Sets LC_CTYPE to the given value during the connection. If you want to use the Exasol ODBC driver in combination with Cognos,
#DATAGRIP CONNECT TO DATABASE BY PEM KEY PASSWORD#
If the value for the parameter is refreshtoken, the connection string will be "EXAHOST=: AUTHMETHOD=accesstoken EXAPWD=" and the password will be your OpenID Refresh Token.įor more information, see Authentication using OpenID.Īutocommit mode of the connection. If the value for the parameter is accesstoken, the connection string will be "EXAHOST=: AUTHMETHOD=accesstoken EXAPWD=" and the password will be your OpenID Access Token. Specifies the authentication method for OpenID connections. This data can be, for example, the data of prepared parameter values. Sets the encoding of ANSI string (SQL_C_CHAR) data to the given value. Sets the encoding of the arguments of ANSI functions to the given value. KeysĪll search patterns in the catalog function can contain ODBC search patterns. The supported keys are described in the following table.
0 kommentar(er)
