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?
Thanks for posting your question!
– Since you are running the SQR using the process sch