We are trying to communicate with SAP HANA using Lab VIEW Database toolkit. We are able to open the connection with the server but when we try to fetch data using query then we are getting following error.
ADO Error: 0x80004005
Exception occured in SAPNewDBMDXProvider.1: sql syntax error: Error occurred while executing a MDX statement. The error message is: Syntax Error : SELECT * FROM "_SYC_BIC"<<<Help Path is C:\Program Files (x86)\SAP\hdbclient\SAPNewDBMDXProvider.hlp and context 0
What we tried:
We successfully ran same query using SAP HANA Studio.
Gaurav k CLD Certified !!!!! Do not forget to Mark solution and to give Kudo if problem is solved.