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
ODBC Connectivity problem
Moderators: chulett, rschirm, roy
-
harishankarp
- Participant
- Posts: 1
- Joined: Mon Aug 27, 2007 12:36 am
- Location: noida
- Contact:
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.