DSXchange

Hi,

The "view data" option in ODBC Connector stage of Datastage Designer connects and shows data, but the job aborts with the below error

The connector could not establish a connection to data source <DSN_name> using user <user_id>

I have checked the values passed to the db connection parameters, nevertheless they are the same while viewing data and while running jobs.

Could you help understand what is that I'm not seeing.

Any help is appreciated.

Thanks

Compute Nodes?

So running the job in Grid is causing this?
How can I prevent it?

Get the compute node names and ask your DBA to configure that database in them.

The account actually got locked, and once password was reset, the job ran successfully.
However we think it is because the password contained special chars like "#"

I have definitely run into this issue before, due to special characters in the password. Thanks for sharing.

That'll do it. There is an explicit warning about special characters in passwords (including how to avoid problems when they're used by mapping to a special sequence such as __036__) in the documentation.