The Starburst ODBC driver V3 series is described in the following pages:
Some connection string keywords are renamed or removed in the v3 release. The following table shows how the old keywords map to the new ones:
Keyword | Note |
---|---|
AccessToken | Unchanged. |
AllowHostNameCNMismatch | Deprecated. See the SSLVerification conversion section. |
AllowHTTPRedirect | The default value changed from false to true . |
AllowMetadataFromMultipleCatalogs | Not implemented yet. |
AllowSelfSignedServerCert | Deprecated. See the SSLVerification conversion section. |
ApplicationName | Unchanged. |
ApplicationNamePrefix | Deprecated, use ApplicationName instead. |
AuthenticationType | See the AuthenticationType conversion section. |
AutoCommit | Obsolete. No longer applicable. |
AutoIPD | Obsolete. No longer applicable. |
CacheAccessToken | Deprecated. Use CacheOAuthToken instead. |
CacheOAuthToken | New. Replaces CacheAccessToken . |
CallingAppName | Obsolete. No longer applicable. |
Catalog | Deprecated. Use Database instead. |
CheckCertRevocation | Obsolete. CRL is always checked. |
ClientCert | Obsolete. No longer applicable. |
ClientPrivateKey | Obsolete. No longer applicable. |
ClientPrivateKeyPassword | Obsolete. No longer applicable. |
ClientTags | Unchanged. |
ConnectionTest | Obsolete. No longer applicable. |
Database | New. Replaces Catalog . |
DefaultVarcharLength | New. Replaces MaxDefaultVarCharLength . |
DelegateKrbCreds | Obsolete. Configure this in your Kerberos KDC instead. |
DelegationUID | Deprecated. Use SessionUser instead. |
Driver | Unchanged. |
EffectiveUserName | Deprecated. Use SessionUser instead. |
ExtraCredentials | Unchanged. |
Host | Deprecated. Use Server instead. |
HTTPProxy | New. Replaces UseProxy , ProxyHost and ProxyPort . |
IgnoreBrokenCatalog | The default value changed from false to true . |
KerberosKeytab | Not implemented yet. |
KerberosPassword | Unchanged. |
KerberosUsername | Unchanged. |
KinitType | Deprecated. Set AuthenticationType accordingly. |
KrbServiceName | Not implemented yet. |
LogFileCount | Unchanged. |
LogFileSize | Unchanged. |
LogLevel | Unchanged. |
LogPath | Unchanged. |
MaxCatalogNameLen | Obsolete. There is no length limit for catalog names. |
MaxColumnNameLen | Obsolete. There is no length limit for column names. |
MaxComplexTypeColumnLength | Obsolete. The max length for complex types (e.g. row, JSON) is 2147483647 . |
MaxDefaultVarCharLength | Deprecated. Use DefaultVarcharLength instead. |
MaxPreparedStatementLength | Obsolete. There is no length limit for prepared statements. |
MaxSchemaNameLength | Obsolete. There is no length limit for schema names. |
MaxTableNameLen | Obsolete. There is no length limit for table names. |
Min_TLS | Obsolete. The driver always uses the Starburst server TLS level. |
MuteServerWarnings | Obsolete. Use SessionProperties to prevent specific warnings. |
NonProxyHosts | New. |
Port | Unchanged. |
ProxyHost | Deprecated. Use HTTPProxy instead. |
ProxyPort | Deprecated. Use HTTPProxy instead. |
ProxyPwd | Unchanged. |
ProxyUid | Unchanged. |
PWD | Unchanged. |
RemoveTypeNameParameters | Obsolete. Type names never have parameters. |
Roles | Unchanged. |
Schema | Unchanged. |
Server | New. Replaces Host . |
ServerVersion | Obsolete. No longer applicable. |
SessionProperties | Unchanged. |
SessionUser | Unchanged. |
SSL | Unchanged. |
SSLVerification | New. |
TimeZoneID | Unchanged. |
TrustedCerts | Unchanged. |
TwoWaySSL | Obsolete. No longer applicable. |
UID | Unchanged. |
UseDSNSchemaForMetadata | Obsolete. No longer applicable. |
UseEqualInMetadataFilters | Obsolete. No longer applicable. |
UseExistingKrbCreds | Deprecated. Set AuthenticationType instead. |
The following table shows how old AuthenticationType
values map to new
AuthenticationType
values:
Old value | New value |
---|---|
No Authentication |
None |
LDAP Authentication |
Password |
JWT Authentication |
JWT |
OIDC Authentication |
OAuth2 |
Kerberos Authentication |
If your current configuration uses DelegateKrbCreds = 1 , use WindowsIntegrated .If your current configuration uses KInitType = KInit with Password , use WindowsPassword .If your current configuration uses KInitType = KInit with Keytab , use WindowsKeytab (not implemented yet). |
The AllowSelfSignedServerCert
and AllowHostNameCNMismatch
keywords are
deprecated but continue to work. The recommended V3 settings are:
AllowSelfSignedServerCert = true
, set
SSLVerification = None
.AllowHostNameCNMismatch = true
, set
SSLVerification = CA
.SSLVerification = Full
.Is the information on this page helpful?
Yes
No