Hi
I gave the ODBC informations of my database in the uvodbc./config file. when i try importing teh ODBC definitions from mt DS Job iam getting the following error
DSR.MetaGeta(GET.TABLES)(SQLConnect('EPICOR','Compass')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified
Do i have to do anything else.Please help me out..
Regards,
SHiva
Creating ODBC Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The .odbc.ini file is usually located in the DataStage engine directory. It is (usually) also referred to by the ODBCINI environment variable. Therefore, if you execute the command echo $ODBCINI you would get the pathname of the .odbc.ini file.
Edit the .odbc.ini file to set up the DSNs that DataStage is to use. Edit the uvodbc.config file in a project to indicate which of the DSNs is to be visible from that particular project.
Edit the .odbc.ini file to set up the DSNs that DataStage is to use. Edit the uvodbc.config file in a project to indicate which of the DSNs is to be visible from that particular project.
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.