Hi,

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.

Thanks for posting your question!

Since you are running the SQR using the process sch

Posted by Nitin Pai
Comments (0)
December 2nd, 2008

Comments (0)

Contact Us