ODBC error in Parallel job ODBC connector Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
manish1005
Participant
Posts: 39
Joined: Thu Nov 23, 2006 11:23 pm

ODBC error in Parallel job ODBC connector Stage

Post by manish1005 »

I am not able to connect to my database through ODBC Connector Stage in Parallel jobs. Server Job ODBC Stage is working perfectly fine.

After typing in DSN Name, username & password in ODBC_Connector stage it gives: "The connetion failed" error when I test the connection. I am using same DSN for server jobs and they are running fine.

Are there any other parameters which need to be set for Parallel ODBC connector stage?? Please suggest.

Btw I am using PostGres Database using psqlodbc-8.1.2 ODBC Driver and unixODBC-2.2.12 ODBC Driver Manager on Solaris10 Sparc machine, if it matters.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”