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