Sandbox Tutorial 8 – ODBC error

to create new topics or reply. | New User Registration


This topic contains 1 reply, has 1 voice, and was last updated by  Marcus Teixeira 1 year, 9 months ago.

  • Creator
  • #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?

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


Viewing 1 replies (of 1 total)

The topic ‘Sandbox Tutorial 8 – ODBC error’ is closed to new replies.

  • Author
  • #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!

Viewing 1 replies (of 1 total)
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.