Home Forums Hortonworks Sandbox Sandbox Tutorial 8 – ODBC error

Tagged: 

This topic contains 1 reply, has 1 voice, and was last updated by  Marcus Teixeira 6 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)