Hi,
When i am trying to import tables/run a job i am getting this error..
DSR.MetaGeta(GET.TABLES)(SQLConnect('DBName','dbuser')): BCI Error:
SQLSTATE=S1000,CODE=80,[DataStage][SQL Client][ODBC]
Somebody please explain me what this error means.
I was able to import tables/run these same jobs till yesterday.jobs using ORA/DB2 plug-ins are running fine.
We are on DS 7.1
Thanks
ODBC issue
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This error is being generated by the ODBC driver manager. Check to make sure that the database server is running, and that none of the connectivity requirements (including password) has changed. Test to verify whether you can connect to the database via ODBC using the test software in branded_odbc. If you can, then try to connect using the DataStage command DS.CONNECT. Somewhere between these two, and perhaps a separate ODBC client, you should be able to track down the cause.
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.