Convert libname statement in oracle engine to OLEDB engine

[Frank_0505]

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

[milts]

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