Page 1 of 1

BCI Error

Posted: Tue Sep 28, 2004 2:55 am
by Kniranjani
Pls help if anyone knows:
1. In UNIX,tried to connect DB2 with BCI function(SQLConnect).
2. Failed with error message:
"SQLSTAT=IM003,CODE=80,[DataStage][SQL Client][ODBC]Specifed driver
could not be loaded"
3. What is wrong?
4. Pls advice the entries of uvodbc.config
:?:

Re: BCI Error

Posted: Tue Sep 28, 2004 3:31 pm
by ogmios
Are you using branded odbc? The ODBC drivers of Datastage are only licensed for use in GUI jobs, not for use in BCI.

Ogmios

Posted: Tue Sep 28, 2004 4:14 pm
by ray.wurlod
Specified driver could not be loaded suggests that the branded_odbc library directory (or the third party ODBC driver's library directory) is not in the search path for libraries. This search path is stored in the environment variable LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on which variant of UNIX you're using.

It's possible that something's not quite right with .odbc.ini or uvodbc.config but, since BCI got as far as "the specified library" I'd tend to discount these as the likely cause.