DATA Step, Macro, Functions and more

Convert libname statement in oracle engine to OLEDB engine

Reply
N/A
Posts: 1

Convert libname statement in oracle engine to OLEDB engine

Hello,

I'm using SAS/ACCESS to access our Oracle database. My working libname statement is like this:

LIBNAME mylib ORACLE USER=userid PW=userpwd PATH="@orapath" SCHEMA=scheme; RUN;

My question is I'm helping one of my colleagues to do the same thing. But her SAS does not licesing ORACLE engine. So I need to rewrite this statement into a OLEDB statement (which I'm not familiar with). I figured it out the statement is something probably look like this:

LIBNAME mylib OLEDB;
PASSWORLD=userpwd;
USER ID=userid;
SCHEMA=schema;
RUN;

But I don't know where to put the PATH thing. Is it equals to the DATA SOURCE?

Please help!

Frank
Super Contributor
Posts: 326

Re: Convert libname statement in oracle engine to OLEDB engine

Posted in reply to Frank_0505
Hi Frank,

you may refer to the online documentation for the libname specifics for OLEDB

http://support.sas.com/documentation/cdl/en/acreldb/63023/HTML/default/a001361171.htm

Hope this helps.

Milton
Ask a Question
Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation