(1170) Unexpected response received from server

Question

I'm able to create a System DSN using the "ODBC Data Source Administrator" with a successfull test.

My Authentication mecanism is "User Name and Passowrd"

SASL checked

SSL Options: "Enable SSL" checked

SSL Options: I'm providing the path to a certificate

BUT, trying to connect using pyodbc with the same parameters (server, port, username and password) gives always the same error below whatever the auth_mechanism provided:

pyodbc.connect("DRIVER={Cloudera ODBC Driver for Impala};\
host={server_address};\
port=21051;\
SSL=1;\
auth_mechanism=GSSAPI;\
user=myusername;\
password=mypassword;\
trustedcerts=cert.pem;\
")

Error: ('HY000', u'[HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) (SQLDriverConnect); [HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170)')

I'm using:

ODBC Version: 03.80
Driver Version: 2.6.0.1000
Bitness: 64-bit
Locale: fr_CA

OS: Windows 10 Pro

momo_a · Accepted Answer

I finally resolved the issue by enclosing UID, PWD, and trustedcerts in braces:UID={MY USERNAME}PWD={MY PASSWORD}trustedcerts={path to file}

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.