regarding drs stage

vijaykumar · Post by **vijaykumar** » Mon Dec 18, 2006 11:57 am

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

DSguru2B · Post by **DSguru2B** » Mon Dec 18, 2006 12:02 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 2:51 pm

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.