DSXchange

Can you please suggest me the remedy for this problem ??
This is regarding the problem with ODBC connection .


This is the error iam getting

|INTU_WLMS_360_RESP_VERTICAL..STG_QUESTIONS: DSD.BCIConnect connecting to epmdev01, call to SQLConnect failed.

SQLSTATE=08S01, DBMS.CODE=-4

[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.|

Welcome aboard. :D

As far as Oracle is concerned, a DataStage job is just another client application.
If the diagnosis is "connection dead" the only thing you can do is find out why. The Oracle driver has been successfully invoked by DataStage - you can tell by the square-bracketed entries in the error message - which indicates that the problem is outside of DataStage - in the network or in Oracle itself.

Have you taken this error to your DBA, discussed it with them?