Architecting, installing and maintaining your SAS environment

SAP HANA connection using SAS/Access Interface ODBC

Reply
Occasional Contributor
Posts: 16

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: 252

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

Occasional Contributor
Posts: 16

Re: SAP HANA connection using SAS/Access Interface ODBC

Posted in reply to AndrewHowell

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

 

 

ERROR: An exception has been encountered.
Please contact technical support and provide them with the following
traceback information:

The SAS task name is [CONTENTS]
Segmentation Violation

Traceback of the Exception:

.../SASHome/SASFoundation/9.4/sasexe/sas(+0x15aa6e) [0x7fd63ff69a6e]
.../SASHome/SASFoundation/9.4/sasexe/sas(+0x4cb0b) [0x7fd63fe5bb0b]
.../SASHome/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144)
[0x7fd63e7b33c4]
/lib64/libpthread.so.0(+0x3b2a60f710) [0x7fd63f9df710]

 

Is the error related to any Hotfix?

 

SAS Super FREQ
Posts: 299

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

Regular Contributor
Posts: 205

Re: SAP HANA connection using SAS/Access Interface ODBC

Which ODBC driver are you using for SAP HANA ?

Ask a Question
Discussion stats
  • 4 replies
  • 588 views
  • 0 likes
  • 4 in conversation