Help using Base SAS procedures

CLI Error - Help Needed

Reply
Frequent Contributor
Posts: 117

CLI Error - Help Needed

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?

Regular Contributor
Posts: 233

CLI Error - Help Needed

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

Frequent Contributor
Posts: 117

CLI Error - Help Needed

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

Super User
Posts: 18,498

CLI Error - Help Needed

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

Frequent Contributor
Posts: 117

Re: CLI Error - Help Needed

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);

Ask a Question
Discussion stats
  • 4 replies
  • 721 views
  • 0 likes
  • 3 in conversation