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.....
Adding a new data source...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Aug 25, 2005 6:33 am
Adding a new data source...
Last edited by sasi_kumarreddy on Wed Aug 02, 2006 10:41 pm, edited 1 time in total.
SASI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
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.
-
- Participant
- Posts: 27
- Joined: Thu Aug 25, 2005 6:33 am
configured in .odbc.ini
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...
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...
SASI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 27
- Joined: Thu Aug 25, 2005 6:33 am