BCI Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Kniranjani
Participant
Posts: 8
Joined: Mon Jul 12, 2004 9:17 am

BCI Error

Post 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
:?:
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: BCI Error

Post 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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply