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 scheduler, you will need to ensure that you can connect to the TARGET database from the server on which the process scheduler is configured. So please verify connectivity from the server.

-          Alternatively, it is recommended to create database link instead of providing this information in the SQR. You can create a SYNONYM to mask the database link.

Thanks

Nitin Pai