DSXchange

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

I have done the following entries:

/opt/Ascential/DataStage/Projects/INMigration-DE/uvodbc.config

/opt/Ascential/DataStage/branded_odbc/odbc.ini

/opt/Ascential/DataStage/DSEngine/uvodbc.config


Are these entries insufficient ? It would be great if you can help me out of this.

My new data source is an oracle database..FYI

Am i in right track..?

Thanks in advance.....

URGENT is an unusual name for a data source.

Etiquette Note
We don't do "urgent" requests here. All contributions are voluntary, in unpaid time. We post as and when we can. If you need urgent answers, sign up for premium level support from your support provider. You will find that urgency comes with a cost.

You also need to check $DSHOME/.odbc.ini

Thank Q

Now i am getting the error like....

DSR.MetaGeta(GET.TABLES)(SQLConnect('OMIN','ominadm')): BCI Error:
SQLSTATE=08001,CODE=-5,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.

can anybody help out on this...

Yes. Either your network administrator or your Oracle DBA.

If u don't mind...

I am able to connect through the SQL editor to the same database..

'SQL Editor' from your PC? Doesn't matter. DataStage is running on your UNIX server and needs to make the connection from there.