06-30-2017 09:42 AM
I am trying to connect SAS to SAP HANA using "SAS/Access for ODBC". I can able to access the SAP HANA DB using below libname statement.
libname test odbc dsn="XXX" user=XXXXX Password=XXXXXX;
But when i am trying to access the tables in EG i got the below error message.
"SAS IOM Data provider has failed to open data.Unspecified error: -2147417848(0x80010108)"
07-03-2017 12:31 AM
A couple of suggestions:
.. immediately after the libname statement, to confirm a 0 return code.
When you say you try to access your tables, do you mean interactively or programmatically? Try examining a known table:
proc contents data=test.table;
Or else try:
proc contents data=test._ALL_ nods; run;
Regardless, please post the code & the log (and the ODBC configuration) for us to help you further
07-03-2017 08:45 AM
are other users experience the same problem? Could you test w/ another user's EG?
If there are any other databases, can you connect to those?
What version of SAS and EG are you using?