Parallel ODBC connections refused

I0360DA · Post by **I0360DA** » Thu Oct 16, 2008 7:33 am

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

Nagaraj · Post by **Nagaraj** » Mon Oct 20, 2008 10:47 pm

This may sound stupid, even i used to get this error, i am sure the error message is more than
"'Connection refused to host: 10.10.34.83; Connection refused' "
correct??
Please go ahead and run the job, it will run properly(if you have given all valid access credentials). do not try to view data thru the odbc connector stage.

i think it is a bug in 8x. Just compile and run.

Thanks
-Raj

I0360DA · Post by **I0360DA** » Mon Oct 27, 2008 7:23 am

The job did not run. It aborted with the following error message.
5063 Abort - core dumped