Hortonworks Sandbox Forum

odbc not showing up in excel 2010

  • #36174
    Mark Malter

    I installed the ODBC driver and the test ran successfully, but when I attempt tutorial 8 and open a spreadsheet and go to Data > From other sources > From Microsoft query, there is no ‘Sample Hortonworks Hive DSN* option in the Choose Data Source dialog box.

    I’m using Excel 2010. Do I need to update to 2013? Or might there be another problem?

to create new topics or reply. | New User Registration

  • Author
  • #36176
    Ron Lee

    Hi! When you created the connection in the ODBC administrator you gave the connection a name. It is at the very top of the dialog box. If you look at the tutorials on setting up ODBC I usually call it Hadoop. The connection name will be what shows up in the list of data sources. If you are still having problems let us know and I can dig up the screenshots for you.


    Mark Malter

    Hi Ron,
    Still having problems. On my Hortonworks Hive ODBC Driver Setup screen I have:
    Data Source Name: Sample Hortonworks Hive DSN
    Description: Sample Hortonworks Hive DSN
    Database: default
    Hive Server 2 and Mechanism User name
    User Name : Hadoop

    In excel, when I go to Data > From other sources > From Microsoft query, in the Choose Data Source dialog box I see only:

    dBASE Files*
    Excel Files*
    MS Access Database*

    But unlike in your Tutorial 8, I don’t have the “Sample Hortonworks Hive DSN*” option in the ‘Choose Data Source’ dialog box.

    Thank you for your help.

    Deepak Pawar

    I have the same issue (however, I am using excel 2007). the connection name does appear in the list when I try to choose the datasource name from excel.
    When I test the connection from ODBC, it was completed successfully.

    Thanks for your help.

    Bill Matera

    I had same problem with using Excel 2010. You need to install the 32-bit driver since Excel 2010 is 32-bit app. Worked fine once I installed it.

    David Chan

    I have almost the same issue with connection with excel.
    I used the name “Sample Hortonworks Hive DSN”
    Currently I am using vmware with hortonwork 2.0 on the linux build
    “dsn contains and architechure mismatch between the driver and application”
    I changed the dsn name to hadoop also still didnt work can you assist with advise on this.

    Bruno Kelpsas

    I am having the same issue in Excel 2013. Driver not showing in Excel 2013. Using 64-bit driver. Did ‘Test’ in ‘ODBC Data Source Administrator’ and it was Successful. I am using latest VMWare Player. Please advise….thanks….Bruno

    Sree Priyanka Uppu

    Thanks Bill.
    I followed your advise and now I can see “Sample Hortonworks Hive DSN” in the ODBC sources for Excel

    Sriraman S

    I have the same problem. Hortonworks ODBC not showing up in the data source dialog box.
    Kindly help me.

    David Chan

    Yah I found out the issue . You need to have MSoffice Pro 2013 or msoffice pro plus to make this work.
    search the article regarding this in Hortonworks. Its a separate article itself.
    took me a long time to find out.


    Same problem using Office 2010, solved with the installation of the 32 bit ODBC driver! 😉

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.