Hortonworks Hive ODBC Driver DSN setup

[#1]

Hi

While doing DSN setup I am getting below error. Please suggest.

FAILED! [Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10060.

[#2]

@Tech Guy

Can you please try to follow below URL and see if that resolve the issue?.

http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-w...

[#3]

@Tech Guy

This can be occur due to many issues like incorrect port or firewall, may be hive service is not up and running or table permission see this post https://community.hortonworks.com/questions/10192/facing-issue-with-odbc-connection.html

[#4]

@ Jitendra

I tried above link previously but got the error mentioned in my thread.

[#5]

@ devers,

I am using Win7. Any suggestion?

[#6]

Can you share a screenshot of what your DSN setup looks like? Or maybe post a bit more details?

Alternatively, do you have any other ODBC connections, or is this the first one you have tried?

[#7]

If you are on a Mac with "El Capitan" (10.11) and run into this, you are likely dealing with a platform specific issue.

The driver and installation does work with 10.10 along with Office 365 (2016)

Possible issue with ODBC Hive and El Capitan

[#8]

@devers.

PFA dsn-setup.jpg

I tried with user name hive and hue but same error.

[#9]

I don't believe the password for hive is "hue"

Did you try maria_dev/maria_dev for name and password?

[#10]

yes. I used hue since it is mentioned in below instruction link

http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-w...

Is there any way to check detailed log which can give me more information about the error ?