Page 1 of 1

ODBC Connectivity problem

Posted: Mon Oct 22, 2007 7:49 am
by harishankarp
I am facing a problem in Connecting to Oracle DB through DataStage.
I have entered DB details into odbc.ini file
and also added DSN entry in uvodbc.config file.
That uvodbc.config is also copied to the project folder.

Following error msg I am getting
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('CRMK','apps_readonly')): BCI
Error: SQLSTATE=IM002,CODE=0,[DataStage][SQL
Client][ODBC][DataDirect][ODBC lib]
Data source name not found and no default driver specified


Please help me,
Thanks in Advance

Posted: Mon Oct 22, 2007 7:57 am
by chulett
a) Welcome!

b) Why not use OCI?

c) Post your entries from both files.

Posted: Mon Oct 22, 2007 1:24 pm
by ray.wurlod
Show (by posting it) that there is an entry for CRMK in uvodbc.config. Show that there is a proper DSN defined for CRMK. Show that the entries can be resolved in tnsnames.ora.