Error with Microsoft ODBC for Oracle. BCI Error.

pavlicic · Post by **pavlicic** » Fri Jun 23, 2006 4:21 am

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

ArndW · Post by **ArndW** » Fri Jun 23, 2006 5:05 am

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?

pavlicic · Post by **pavlicic** » Fri Jun 23, 2006 5:09 am

ArndW wrote: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? ...

yes, it's a system dsn

ArndW · Post by **ArndW** » Fri Jun 23, 2006 6:57 am

Can you access the DB using that DSN through MSQuery?

pavlicic · Post by **pavlicic** » Fri Jun 23, 2006 12:45 pm

How can i use MSQuery? I don't know this tool...

ArndW · Post by **ArndW** » Sat Jun 24, 2006 8:33 am

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.

Chuah · Post by **Chuah** » Sun Jun 25, 2006 8:34 pm

Why not use the Oracle ODBC if that works ? You might want to try to reinstall your MS ODBC drivers.