以下为正文

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


评论关闭
IT干货网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!

【HANA系列】SAP HANA SQL获取当前日期加若干天后的日期