Creating ODBC Connection

[shiv4003]

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

[hexa]

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

[shiv4003]

Hi

What is .odbc.ini file?

What should i add in that?

[shiv4003]

Hi Hexa


What is .odbc.ini file?

What should i add in that?

Please let me know.

Regards,
Shiva

[ray.wurlod]

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.