Sandbox Tutorial 8 – ODBC error

to create new topics or reply. | New User Registration

Tagged: 

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

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

Viewing 1 replies (of 1 total)

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

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

    Collapse
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.