DSXchange

Posted: **Wed Dec 26, 2007 3:31 am**

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

Posted: **Wed Dec 26, 2007 4:42 am**

Shiva,

I add entry in uvodbc.config and .odbc.ini as well.

Pls. search there is lot of posting available reg in this topic

Hexa

Posted: **Wed Dec 26, 2007 5:12 am**

Hi

What is .odbc.ini file?

What should i add in that?

Posted: **Wed Dec 26, 2007 5:20 am**

Hi Hexa

What is .odbc.ini file?

What should i add in that?

Please let me know.

Regards,
Shiva

Posted: **Wed Dec 26, 2007 1:34 pm**

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.

DSXchange

Creating ODBC Connection

Creating ODBC Connection

Re:

Re.