data source name not found

Suparv · Post by **Suparv** » Thu Jun 16, 2005 2:41 pm

Hi Guys

we have an Oracle 10 g target database and we have an enterprise edition
7.5 on Aix 5x.After adding the dsn name (<DWDEV.WORLD>) AND DBMSTYPE = ODBC in the uvodbc.config file and when iam tryin to import odbc table definitions iam gettin the following error.

DSR.MetaGeta(GET.TABLES)(SQLConnect('dwdev','dw_admin')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC
lib] Data source name not found and no default driver specified.

Iam able to access the target database using Toad.Your response is appreciated.

Thanks
Suparv

ray.wurlod · Post by **ray.wurlod** » Fri Jun 17, 2005 2:56 am

Looks like you still need to add the DSN into .odbc.ini.

chulett · Post by **chulett** » Fri Jun 17, 2005 6:34 am

Either that or start using the OCI stage and 'Plug-in Metadata' rather than ODBC.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 17, 2005 7:19 am

In either case also check that your Oracle environment variables are correctly set (in the $DSHOME/dsenv script) and that tnsnames.ora is properly populated.