I am not able to connect to SQL database through ODBC Connector Stage in a Parallel job. The Server jobs that connect to the SQL database using the ODBC Stage are working perfectly fine. The odbc.ini file and config file have been setup for the Server jobs. I am using the same DSN, user ID and password for the Parallel job but getting the following error message:
'Connection refused to host: 10.10.34.83; Connection refused'
I have searched the forums but have not found an answer to this problem.
Am I missing something in another file that needs to be setup for the ODBC parallel to work?
Please advise.
I0360DA