hi,
my design is DRS---->TRANSFORMER----->DRS
iam getting error: TNS COULD NOT RESOLVE SERVICE NAME.
when i use ODBC---->TRANSFORMER--->ODBC.
its working fine.
why is that when i use DRS STAGE iam getting error, plz help me.
my DSN is correct,since iam able to extract data using ODBC, why not with DRS, plz help me.why is that iam getting error.
TNS COULD NOT RESOLVE SERVICE NAME.my source is oracle database.
cheers;
vijaykumar
regarding drs stage
Moderators: chulett, rschirm, roy
The TNSNAMES.ORA file is either not there or is not updated with the current server that you are trying to access. It works with odbc because all that info is present in the uvodbc.config file and .odbc.ini file. Check and update your TNSNAMES.ORA file.
Also, you can use odbc and DRS stage. Choose ODBC as database type and you will be able to connect.
Also, you can use odbc and DRS stage. Choose ODBC as database type and you will be able to connect.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's also possible that the environment variables for Oracle (particularly ORACLE_HOME) are not correctly set for the process executing the DataStage job, so that it can not find the tnsnames.ora file.
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.