question Re: (1170) Unexpected response received from server in Support Questions

(1170) Unexpected response received from server

momo_a — Fri, 16 Sep 2022 14:05:51 GMT

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

Re: (1170) Unexpected response received from server

momo_a — Tue, 29 Jan 2019 16:35:26 GMT

I finally resolved the issue by enclosing UID, PWD, and trustedcerts in braces:

UID={MY USERNAME}

PWD={MY PASSWORD}

trustedcerts={path to file}

Re: (1170) Unexpected response received from server

VinayRg — Tue, 18 Jun 2019 18:00:05 GMT

Hi,

I had the same error and I tried the solution you have provided.

Now it's showing a different error code saying ERROR [HY000] [CLOUDERA] [Driver Support] (1140).

Unable to load CA certificates from the location.

Could you provide a solution for this?

Thanks in advance.

Vinay

Re: (1170) Unexpected response received from server

pudnik26354 — Fri, 27 Mar 2020 23:08:26 GMT

...but WHERE did you put those parameters?

I am having the same issue. My file DSN will connect just fine in the ODBC Administrator applet, but in pyodbc it gives the same error. Did you add those parameters to your DSN?

Re: (1170) Unexpected response received from server

ask_bill_brooks — Sun, 29 Mar 2020 00:15:34 GMT

@pudnik26354

As this thread was marked 'Solved' in Jan 2019 you would have a better chance of receiving a useful response by starting a new thread. This will also provide you with the opportunity to provide details specific to your environment that could aid others in providing a more accurate answer to your question.

Re: (1170) Unexpected response received from server

domboste — Wed, 13 May 2020 14:11:51 GMT

@pudnik26354 Did you already solve your problem. I have the same issue using iodbc and pyodbc on a debian based system.

Re: (1170) Unexpected response received from server

pudnik26354 — Tue, 19 May 2020 15:09:26 GMT

I think it was because if you use kerberos, the kerberos credentials have to be in upper case because they are case sensitive