MetaData import Erro with 10g

via · Post by **via** » Tue Nov 13, 2007 5:30 pm

All the jobs (DRS stages) were able to run with out any issues using ODBC connection.
An error is popping out only when importing metadata.

"DSR.MetaGeta(GET.TABLES)(SQLConnect('abc','xyz')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified "

TNS has all the entires and when data is viewed in DRS output/input tabs, data is showing with out any issues.

I searched for similar issues and were able to verify the uvodbc.config and found out it has all the entires.

Any suggesions?

ray.wurlod · Post by **ray.wurlod** » Tue Nov 13, 2007 10:58 pm

Have you also checked tnsnames.ora ?

Is casing as well as spelling correct?

via · Post by **via** » Wed Nov 14, 2007 9:33 am

ray.wurlod wrote:Have you also checked tnsnames.ora ?

Is casing as well as spelling correct?

Hello Ray,

tnsnames.ora has all the entries (spelling and casing are same) and we have no isses in connecting to database up on running a job.
This error is popping up only when importing the table def!

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 3:13 pm

Are there any "funny" characters (for example "#", ,"?", etc.) in the password?

via · Post by **via** » Wed Nov 14, 2007 4:18 pm

ray.wurlod wrote:Are there any "funny" characters (for example "#", ,"?", etc.) in the password?

Password is a simple 'welcome'