The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

The following table lists the connection string attributes supported by the Greenplum Wire Protocol driver.

Table 1. Greenplum Wire Protocol Attribute Names
Attribute (Short Name) Default
AlternateServers (ASRV) None
ApplicationUsingThreads (AUT) 1 (Enabled)
AuthenticationMethod (AM) 0 (No Encryption)
BatchMechanism (BM) 1 (SingleRowInsert)
ConnectionReset (CR) 0 (Disabled)
ConnectionRetryCount (CRC) 0
ConnectionRetryDelay (CRD) 3
CryptoLibName (CLN)

Empty string
CryptoProtocolVersion (CPV) TLSv1.2, TLSv1.1, TLSv1, SSLv3
Database (DB) None
DataSourceName (DSN) None
Description (n/a) None
EnableFIPS (EF) Disabled
Enable SQLDescribeParam 1 (Enabled)
EnableKeysetCursors (EKC 0
EncryptionMethod (EM) 0 (No Encryption)
ExtendedColumnMetaData (ECMD) 0 (Disabled)
FailoverGranularity (FG) 0 (Non-Atomic)
FailoverMode (FM) 0 (Connection)
FailoverPreconnect (FP) 0 (Disabled)
FetchRefCursors (FRC) 1 (Enabled)
FetchTSWTZasTimestamp (FTSWTZAT) 0 (Disabled)
FetchTWFSasTime (FTWFSAT) 0 (Disabled)
GSSClient (GSSC) native
HostName (HOST) None
HostNameInCertificate (HNIC) None
IANAAppCodePage (IACP) UNIX ONLY 4 (ISO 8559-1 Latin-1)
InitializationString (IS) None
KeepAlive (KA) Disabled
KeysetCursorOptions (KCO) 0 - RowID Columns
KeyPassword (KP) None
KeystorePassword (KSP) None
Keystore (KS) None
LoadBalanceTimeout (LBT) 0
LoadBalancing (LB) 0 (Disabled)
LoginTimeout (LT) 15
LogonID (UID) None
MaxCharSize (MCS) None
MaxLongVarcharSize (MLVS) None
MaxPoolSize (MXPS) 100
MaxVarcharSize (MVS) None
MinPoolSize (MNPS) 0
OpenSSLConfigFile (OSSLCNF)

install_dir\drivers\openssl.cnf (Windows)

install_dir/lib/openssl.cnf (UNIX/Linux)
OpenSSLProviderPath (OSSLPP)

install_dir\drivers (Windows)

install_dir/lib (UNIX/Linux)
Password (PWD) None
Pooling (POOL) 0 (Disabled)
PortNumber (PORT) 5432
QueryTimeout (QT) 0
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ServicePrincipalName (SPN) None
SSLLibName (SLN)

Empty string
TransactionErrorBehavior (TEB) 1 (Rollback Transaction)
Truststore (TS) None
TruststorePassword (TSP) None
UnboundedNumericPrecision (UNP) 1000
UnboundedNumericScale (UNS) 6
ValidateServerCertificate (VSC) 1 (Enabled)
XMLDescribeType (XDT) -10

This section includes the following topics: