Architecting, installing and maintaining your SAS environment

SAP HANA connection using SAS/Access Interface ODBC

Reply
Occasional Contributor
Posts: 15

SAP HANA connection using SAS/Access Interface ODBC

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)" 

 

Thanks.

Moderator
Posts: 238

Re: SAP HANA connection using SAS/Access Interface ODBC

A couple of suggestions:

 

Firstly, place

%put &=SYSLIBRC;

 .. 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;
run;

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

SAS Super FREQ
Posts: 291

Re: SAP HANA connection using SAS/Access Interface ODBC

Hi,

 

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?

 

Thanks

Anja

Ask a Question
Discussion stats
  • 2 replies
  • 201 views
  • 0 likes
  • 3 in conversation