RE: [cinjug-users] The specified DLL "DB2I..my_stored_proc" could not be loaded

["James Carman" <james@xxxxxxxxxxxxxxxxxxxx>]

The DDL usually needs to be on your path or your LD_LIBRARY_PATH.  Try dropping the dll file into your windows\system32 dir (if on windows) to see if that solves the problem, or switch to a “thin” or type 4 driver.

 

-----Original Message-----
From: Akalamkam, Pardha [mailto:Pardha.Akalamkam@xxxxxxxxxx]
Sent: Friday, August 13, 2004 4:36 PM
To: users@xxxxxxxxxx
Cc: Akalamkam, Pardha; Gandu, Srini
Subject: [cinjug-users] The specified DLL "DB2I..my_stored_proc" could not be loaded

 

-->

Hi all,

I am using WSAD5.1 and DB2 UDB7.2.

db2 driver path is: c:\db2client\SQLLIB\java12\db2java.zip

 

When I run one of my client apps(ejb,classes) some of the classes are

calling stored procedures then I get the following exception on my

wsad test server console:

 

com.bis.common.base.MyException: Base executeCallableStatement()

failed.:

[IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL

"DB2I..my_stored_proc" could not be loaded.

 

I am getting this error only when a program trying to call stored

procedures other than that it is fine retrieving the database records

and stuff like that.

 

WSAD DSN for driver and JNDI mapping looks good to me...I tried to re

install my db2 client but still same problem...

Would you guys please help me in this regard....that am I missing

anything to configure in WSAD or DB2???

 

Srini