Hortonworks Sandbox Forum

Sandbox Tutorial 8 – ODBC error

  • #40536

    Hi all,

    Following the instructions in the tutorial 8 to connect Excel to Hive ODBC via Microsoft Query, I get the following error message:
    “The specified DSN contains an architecture mismatch between the driver and application”

    I’m not sure if it does not use the correct ODBC or what… because, when I open the ODBC Administrator and test the connection, it works fine.

    Any guess?

    Details:
    Windows 7 (64 bits)
    HW Sandbox 1.3 (64 bits)
    HW ODBC driver (64 bits)
    MS Excel 2010 (64 bits)

    Thanks,
    Marcus

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #40542

    It has been solved. I figured it out my MS Excel 2010 was actually 32 bits. Then I installed the HW ODBC driver 32 bits and it worked perfectly!

The topic ‘Sandbox Tutorial 8 – ODBC error’ is closed to new 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.