Hortonworks Sandbox Forum

ODBC connection problem

  • #48060
    Wade Walker

    I have followed the tutorial to the letter, and have created a system DSN as instructed, but none of my tools (Excel (2010), Lumira, Microstrategy desktop) can see the DSN I have created with the Hortonworks ODBC driver..

    I have reviewed several of the posts on this forum and have tried several things, but still no luck.

    The driver I downloaded from the Hortonworks site was difficult to find. Ultimately, I found HortonworksHiveODBC64.msi, downloaded and executed it.

    I have also tried to connect through JDBC using hive-jdbc-0.10.0.jar with no luck.

    I have spent hours on this and am pretty fed up…any suggestions?? Thanks

to create new topics or reply. | New User Registration

  • Author
  • #48063
    Wade Walker

    Further on this, what is bizarre is it seems that the Hortonworks ODBC (v1.3..it was all I could find) is not visible…”Choose data source” it is not there. If I choose “New Data Source”, every other ODBC known to man appears as an option…except Hortonworks….

    I repeat : this driver IS installed….but it just seems not to be visible!

    Wade Walker

    Another update : the problem was that I was using 64 bit ODBC with 32 bit apps. I downloaded the 32 bit driver and it became visible.

    now I have a new problem…when connecting with client tools I get this aerror : “(34) error from hive : could not resolve host for client socket”

    I cannot find any references that are of any use on the forum or the web in general… any help??

    Mungeol Heo

    After you installed ODBC driver, there will be 32-bit ODBC Administrator.
    64-bit ODBC Administrator for 64 bit ODBC driver.
    Runt it and change the value of host box.

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.