Ask the Experts - 51

Posted by Nitin Pai
December 2nd, 2008


I am writing an interface SQR to connect 2 databases. We have created ODBC connection, and using the -db connection string variable for select/sql statements.

The program runs correctly with SQRW. While running in Porcess Scheduler, I am getting the error message as “Could not connect to datasource specified in -db variable: ‘DSN =; UID=;PWD=”. It picks up the DSN connection string perfectly.

Is there any security related things blocking the SQR to run in Process Scheduler? I suppose the DB LINK has to be mentioned somewhere in App Server. It runs perfectly with SQRW. What settings needed to run in 3-tier?
Please update.


Thanks for posting your question!

Since you are running the SQR using the process sch

Comments (0)