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

[sajeevp]

hi All

thanx in advance

some prob with DB2 - (i am new to DB2)

i am using SPs to insert data to the database.

the following error is coming at the time of calling th SP.
-------------------------------
[IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "up_Request_GN_Insert" could not be loaded
------------------------------

i came to know this erorr is coming bcos of the DLL is not it the LIB path.. so i copied that DLL to the LIB path

i tried to rename the DLL same as the procedure name up_Request_GN_Insert.DLL and started the application again.. now the following error is coming..

-------------------------------
[IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "up_Request_GN_Insert" is loaded and the specified "up_Request_GN_Insert" function could not be executed
------------------------------

can u pls advice me to solve the prob..?? pls tell me where i am missing..

thanx again..

Rgds
Sajeev P

 

[pganesh5]

Hi Sanjee

how are you? Did u try this below one. i am Ganesh. let me know.

SQL1109N When Connecting from a Windows or OS/2 Client

Symptom
The SQL1109N error message is received when trying to connect from a Windows or OS/2 client.

Possible Cause
There are two versions of the NWCALLS.DLL and the TLI_SPX.DLL files: one for OS/2 and one for Windows. These files may not be in the correct location.

Action
The NWCALLS.DLL file from Novell's NWDLL2.exe package should be in the WINDOWS\SYSTEM directory. Ensure that Windows is not trying to load the OS/2 version of the NWCALLS.DLL file.