can't import table definition from oracle 9i

fahad · Post by **fahad** » Tue Mar 22, 2005 9:27 am

Hi all,
i am trying to connect to oracle 9i on unix from my pc through datastage but couldn't.
when i want to import table definitions i got this message
"DSR.MetaGeta(GET.TABLES)(SQLConnect('RDBPROD','rdb')): BCI Error:
SQLSTATE=IM004,CODE=0,[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

although i can connect through the same ODBC driver by MS Excel.
what do u think the problem is?

thanks in advance

kduke · Post by **kduke** » Tue Mar 22, 2005 9:32 am

This is a Microsoft driver. You need an Oracle driver to connect to Oracle. Load the Oracle client first.