1945015 - HANA ODBC error due to mismatch of version

Symptom

When you create ODBC DSN for HANA server connection, you will see the error message like this :

"The specified DSN contains an architecture mismatch between the driver and the application"

Environment

• HANA Studio/Client
• MS Excel 2010

Reproducing the Issue

1. You create ODBC DSN for HANA server connection.
2. Open Excel 2010.
3. Select 'Data->From Other Sources->From Data Connection Wizard'.
4. Select ODBC DSN click Next and then select the HANA ODBC DSN, specify the username and password for HANA server click Test Connection.
5. The error is displayed.

Resolution

• If MS Office is 64 bit, then you have to use 64 bit HANA client.
• If MS Office is 32 bit, then use 32 bit HANA client.

Keywords

odbc, Data Source Name, ODBC for HANA, MDX

Header Data

Released On	04.04.2014 22:40:01
Release Status	Released to Customer
Component	HAN-STD-DEV-MOD SAP HANA Analytical Modeling
Priority	Normal
Category	Problem
Database	HDB 1.0