SqlDbx Forum

Rajkumar

Member

Cloudera HIVE ODBC Connector connecting to Hive from SQLDBX

I created a new DSN using Cloudera HIVE ODBC connector. Tested the connection using the test option in the DSN itself . Test was successful. I created the new DSN under "SYSTEM DSN" as well as "USER DSN" in ODBC data sources 64 bit.
Now the problem is , I'm unable to pull this DSN in sqldbx. I opened SQLDBX , Chose "New connection" from File. Chose DBMS Type as "ODBC". But the newly added DSN is not getting listed here.
Question: How to list the newly added DSN in SQLDBX to use it connect to the database.

Rajkumar

Member

Re: Cloudera HIVE ODBC Connector connecting to Hive from SQLDBX

Update:
I used 64 bit driver to create the DSN and May be SQLDBX can only accept 32 bit drivers. I have sqlDbx profession version 3.64

geo

Member

Re: Cloudera HIVE ODBC Connector connecting to Hive from SQLDBX

Perhaps you installed sqldbx 32-bit?

Check the executable, you should be running SqlDbx64.exe

Last edited by geo (2019-11-08 16:10:32)