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.|
ODBC connection Error
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
