04-02-2012 01:21 PM
I keep getting the following error when running my program (in batch mode):
ERROR: CLI error trying to establish connection: Specified driver could not be loaded due to system error 1114: A dynamic link library(DLL) initialization routine failed. (Oracle in OraClient10g_home1, C:\oracle\product\10.2.0\client_1\BIN\SQORA32.DLL).
I checked and the DLL file does exist in the specified location.
Also, this error ONLY appears when I run the program in batch mode. Running it from the normal sas window does not cause a problem...
04-02-2012 03:20 PM
I have it setup as a macro :
%let db = 'Database1';
%let uid = 'RO';
%let pwd = '0202';
Then I use it like this:
connect to odbc (db=&db uid=&uid pwd=&pwd);