I'm guessing your SAS is 64-bit version. Your Oracle client that SAS loads, which it will find in your PATH, must also be 64-bit.
SAS Tech Support can help. This diagnostic program (run and save the log) can provide a lot of good information to solve it quickly. I'm assuming you're running this with SAS for Windows.
%put Site: &syssite Release: &sysvlong System: &sysscp &sysscpl; %put &sysuserid;
%let SASROOT=%SYSGET(SASROOT);
%put %quote(&SASROOT);
%macro doit(command);
filename p pipe &command lrecl=32767;
data _null_;
infile p;
input;
put _infile_;
run;
%mend;
option LS=256;
%doit("set");
* windows only;
%doit("dir ""&SASROOT\access\sasexe\sasio*""");
%doit("reg query ""HKLM\Software\Oracle"" /s");
%doit("reg query ""HKLM\Software\Wow6432Node\Oracle"" /s");
%put %quote(%sysget(PATH));
libname oralib oracle user=orauser password=orapass path=orapath;
... View more
