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.