Home Forums Hortonworks Sandbox ODBC on WIndows 8

This topic contains 5 replies, has 4 voices, and was last updated by  Tunji Akinbami 6 months ago.

  • Creator
  • #44513


    I’ve installed Sandbox 2.0 and that works fine, except setting up ODBC. I’ve followed the tutorial step by step, but it still doesn’t work. Anyone got this to work? Could it be Windows 8 is the problem?

    The issue is setting up the ODBC, I can’t seem to get a connection.

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

  • Author
  • #47140

    Tunji Akinbami

    Hi.. Windows 8 user here. I had a similar problem with this but I was able to fix this. Follow these steps it should work:

    1. Close the VM VirtualBox if you’re still running it.
    2. Open the VirtualBox Manager, Click File-Preferences then Network
    3. You should see a Host -only Networks tab there. In the selection panel, select Virtual Host-Only Ethernet Adapter
    4. Click on the screwdriver icon and you should the values for the DCHP server settings. Click OK.
    5. Navigate back to the VirtualBox manager again, This time click Settings.
    6. Under settings click Network, Click on the Adapter 2 tab and Enable Network Adapter. Make sure it’s Attached to the Host -only Adapter. Click OK
    7. Boot VM VirtualBox and once you’ve been prompted to login hit Alt + F5 where you’re supposed to login. I believe it’s root for username and hadoop for password.
    8. Hit the command ifconfig. You should see the address for eth1. The IP address listed there should be used in the ODBC configuration settings.
    You should be good to go from there.


    Balaji Vijayan


    Where can I find the installation instructions for the ODBC connector for Sandbox 2.0? I tried searching both Google and the Hortonworks site and all references point back to Sandbox 1.2 and 1.3. I’m having the same issues as Helge.

    In addition the tutorial that is pulling from Github is showing images for configuring VirtualBox on a Mac despite the text indicating that the instructions are for Windows 7. The key difference is VirtualBox in Windows does not have the configuration settings for DHCP that Mac offers. Screenshot: http://screencast.com/t/JH4NFduYgP

    All assistance with setting up the ODBC connector for Sandbox 2.0 would be appreciated.



    For the record, I’ve now tried ODBC32-bit, with the same result. I can’t find any use in the errormessage, so any clues would help…


    I’ve used the tutorial in Sandbox 2.0. I don’t believe the issue is related to Excel, as I never get that far: This is the result from the “Test” in the ODBC Admin tool:

    Driver Version: V1.2.13.1018

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (34) Error from Hive: connect() failed: errno = 10060.


    Cheryle Custer

    Hi Helge,

    are you using the tutorials from the Website or the tutorials in the Sandbox 2.0? The tutorials on the Website are still for Sandbox 1.3 and some don’t work with 2.0 — specifically the ODBC connector.

    Also make sure you’re using the right version of the connector. Excel 2008 and earlier can use only the 32-bit driver.

Viewing 5 replies - 1 through 5 (of 5 total)