topic CLI Error - Help Needed in SAS Procedures

CLI Error - Help Needed

vomer — Mon, 02 Apr 2012 17:21:46 GMT

Hi everyone,

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...

Any tips?

CLI Error - Help Needed

Hima — Mon, 02 Apr 2012 17:28:24 GMT

contact Admin and ask him/her to install the driver.

CLI Error - Help Needed

vomer — Mon, 02 Apr 2012 17:31:50 GMT

Driver is installed...as stated, error only occurs in batch mode not GUI...

CLI Error - Help Needed

Reeza — Mon, 02 Apr 2012 17:57:18 GMT

Can you post the connection code you are using to submit?

Re: CLI Error - Help Needed

vomer — Mon, 02 Apr 2012 19:20:03 GMT

I have it setup as a macro :

%let db = 'Database1';

%let uid = 'RO';

%let pwd = '0202';

Then I use it like this:

proc sql;

connect to odbc (db=&db uid=&uid pwd=&pwd);