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
08-28-2017 11:32 AM
Thanks for the reply.
Error seems inconsistent. I am trying to view the tables from SAS foundation(using -nodms option) instead of EG. Because it gives the error message more accurately.
Below is the code
proc contents data=md_read._ALL_ nods;
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following
The SAS task name is [CONTENTS]
Traceback of the Exception:
Is the error related to any Hotfix?
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?