【HANA系列】SAP HANA ODBC error due to mismatch of version
公众号:matinal
本文作者:matinal
前言部分
大家可以关注我的公众号,公众号里的排版更好,阅读更舒适。
正文部分
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
- You create ODBC DSN for HANA server connection.
- Open Excel 2010.
- Select 'Data->From Other Sources->From Data Connection Wizard'.
- Select ODBC DSN click Next and then select the HANA ODBC DSN, specify the username and password for HANA server click Test Connection.
- 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
公众号:matinal
本博作者:matinal
-------------------------------------------
欢迎来到matinal的博客
如果觉得这篇文章对你有小小的帮助的话,记得在右下角点个“推荐”哦,博主在此感谢!