Hi all,
I've got this error with a Microsoft ODBC for Oracle in a job:
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('prueba','siacrh')): BCI Error:
SQLSTATE=NA000,CODE=0,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle]
Anyone know what's the problem? With Oracle ODBC works fine.
Thanks in advance
Error with Microsoft ODBC for Oracle. BCI Error.
Moderators: chulett, rschirm, roy
GET.DSNINFO should help a bit - it is trying to get the DSN and something is going wrong. Have you declared this as a SYSTEM dsn?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Can you access the DB using that DSN through MSQuery?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I comes as part of the extras for Microsoft Office and also with access and I think it might be available as a separate download from Microsoft as well. It is a simple tool and we've used it for years to check base connectivity for ODBC. If it doesn't work in MSQUERY then don't bother trying to figure out why it isn't working with DataStage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>