Hi,
I’ve installed the Dremio ODBC drivers on our Debian cloud VM (alien converted from the rpm).
I manually created the /etc/odbc.ini file with the following sample contents:
[ODBC Data Sources]
Dremio ODBC 64-bit=Dremio ODBC Driver 64-bit
[Dremio ODBC 64-bit]
Description=Dremio ODBC Driver (64-bit) DSN
Driver=/opt/dremio-odbc/lib64/libdrillodbc_sb64.so
# The DriverUnicodeEncoding setting is only used for SimbaDM
# When set to 1, SimbaDM runs in UTF-16 mode.
# When set to 2, SimbaDM runs in UTF-8 mode.
#DriverUnicodeEncoding=2
# Values for ConnectionType, AdvancedProperties, Catalog, Schema should be set here.
# If ConnectionType is Direct, include Host and Port. If ConnectionType is ZooKeeper, include ZKQuorum and ZKClusterID
# They can also be specified on the connection string.
# AuthenticationType: No authentication; Plain;
ConnectionType=Direct
HOST=0.0.0.0
PORT=31010
LogLevel=DEBUG
LogPath=/home/mike
ZKQuorum=[Zookeeper Quorum]
ZKClusterID=[Cluster ID]
AuthenticationType=Plain
UID=mikeharbrdata
PWD=<removed>
#DelegationUID=
AdvancedProperties=CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;NumberOfPrefetchBuffers=5;
Catalog=TEST1
Schema=
SSL=0
DisableHostVerification=0
DisableCertificateVerification=0
TrustedCerts=/opt/dremio-odbc/lib64/cacerts.pem
UseSystemTrustStore=0
# The key, "UseExactTLSProtocolVersion", toggles between "Min_TLS" or "TLSProtocol".
# UseExactTLSProtocolVersion=1 indicates that the driver should use the exact TLS Protocol version to communicate with the Dremio node.
# UseExactTLSProtocolVersion=0 indicates that the driver should use the minimum TLS Protocol version to communicate with the Dremio node.
UseExactTLSProtocolVersion=0
Min_TLS=
TLSProtocol=
With pyodbc installed I am testing with the following script
import pyodbc
cnx = pyodbc.connect("DSN=Dremio ODBC 64-bit", autocommit=True)
and this is throwing the following error
Traceback (most recent call last):
File "test.py", line 2, in <module>
cnx = pyodbc.connect("DSN=Dremio ODBC 64-bit", autocommit=True)
pyodbc.InterfaceError: ('28000', '[28000] [Dremio][Connector] (40) User authentication failed. Server message: [30017]User authentication failed (please check the username and password).[Server message was: (7d2dc15a-8b99-4378-b0ad-bbb01938b86b) Invalid user credentials, user mikeharbrdata] (40) (SQLDriverConnect)')
Could you advise of any additional configuration steps or adjustments to the odbc.ini that are required.
I can connect using the same credentials to the dremio web ui.
Kind Regards
Mike Smith