Reply
New Contributor
Posts: 1
Registered: ‎01-24-2018

Help: Issues with proper ODBC Impala Connection String

Hello,

 

I am having difficulty connecting to Impala.  We have been succesful in the past connecting to Impala from local desktop but now need to make this connection on a server that has ODBC set up. 

 

Everytime I try to make the connection I get the error that Data Source Name not found and no driver specified...I have confirmed that the DSN is correct and that the Clouder ODBC Driver for Impala is installed on the server

 

Data Source Name: ECM_SDM

Mechanism: SASL User Name and Password (SSL)

Host: "my confirmed host name"

Port: 21050

Transport Buffer SIze:1000

 

Connection String: - I have tried different variations of this but have had no luck

 

odbc:DSN=ECM_SDM;Driver=Cloudera ODBC Driver for Impala;Host= "My Host Name";UID="My UID";PWD="My Password";Port=21050;

 

Any support is greatly appreciated!

 

 

Scott

Announcements