When you installed the Oracle client, did you do it as Administrator and make it available to all users?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Can you tnsping or do anything as the specific DataStage user? It seems the error message is a permissions issue to access the Oracle installation directories for the client software.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
chulett wrote:Only valid advice for UNIX servers, I'm afraid. No such thing on Windows.
ops sorry.. i'm living in the unix world... Windows should have the path for this Library (oraoci9.dll) defined in some place, right?... did you try reboot? this always help.
Thank you very much for all your suggestion. I know I have tried all my options. Thought of solving this issue today but need to catch my flight now. We will reboot the DS server next week when we are in and let you guys know.
Ken, yesterday, I was able to tnsping yesterday. I will let you know.