The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hortonworks Sandbox Forum

Issue on Tutorial 7

  • #46931
    Carolus Holman

    How to Install and Configure the Hortonworks ODBC driver on Windows 7, I am getting the following error when trying to connect the 64-BIT ODBC Driver after clicking the Test Connection Button: SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: connect() failed: errno = 10060. TESTS COMPLETED WITH ERROR.

    The host machine IP is

    ODBC Driver is v1.2.0.1005 64 Bit.
    Host IP:
    Port: 1000
    Hive Server 2
    User Name

    The user name it started with was “sandbox”, I have tried “hue” (Hue) and “root”

    I am using Oracle-VB
    1st adapter is NAT
    2nd is Host-Only

    Host Only Network Details: IPv4 Address:

    I have tried telnet to the IP but get no response. On port 10000.

    I have tried many different ways to connect, nothing is working, in every case i get the same error.

  • Author
  • #46932

    Hi Carolus,

    This is because you are trying to connect to localhost on and it is your machine which wont be listening on this.
    Oracle VirtualBox allows for port forwarding which works around this issue – if you look into the network configuration of the machine you will see the port forwarding and the port you need to use to telnet & connect the driver to.

    Let me know how you get on,



    Carolus Holman

    Thanks Dave for your prompt response, however I am not following what you are saying. I can connect to the Sandbox on port and other utilities, I can telnet to 2222 no problem.

    I followed the instructions for the ODBC connection. The Host adapter IP address is different, when I try to change it, it goes back to the

    What I think you are trying to tell me is that my Host machine is listening on the same port, therefore can’t forward the 192 ODBC request?
    How is this remedied?



    Hi Carolus,

    If you go into Oracle Virtual Box and highlight the sandbox, then go to settings and go to Network – if you click on the “Port Forwarding Tab” you will see that 10000 maps to port 2200 (by default)

    So you should point your ODBC driver at port 2200 on and see if that works for you.



    Carolus Holman

    That worked flawlessly! I don’t think I could have figured that one out, thanks for your help.
    So ODBC Host
    Port 2200
    Also I changed the User to root.

The forum ‘Hortonworks Sandbox’ is closed to new topics and replies.

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.