Convert libname statement in oracle engine to OLEDB engine

Frank_0505 — Tue, 16 Mar 2010 22:15:22 GMT

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

Re: Convert libname statement in oracle engine to OLEDB engine

milts — Wed, 17 Mar 2010 04:43:51 GMT

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

topic Re: Convert libname statement in oracle engine to OLEDB engine in SAS Programming

Convert libname statement in oracle engine to OLEDB engine

Re: Convert libname statement in oracle engine to OLEDB engine