Member since
01-25-2019
2
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
44431 | 01-29-2019 08:35 AM |
01-29-2019
08:35 AM
1 Kudo
I finally resolved the issue by enclosing UID, PWD, and trustedcerts in braces: UID={MY USERNAME} PWD={MY PASSWORD} trustedcerts={path to file}
... View more
01-25-2019
08:31 AM
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
... View more
Labels:
- Labels:
-
Apache Impala