Problem calling Java stoproc from VB

Dominic Raj

Problem calling Java stoproc from VB
I've the following problem in running a Java stored procedure called from a
Visual basic client program.
The stored procedure was developed using stored procedure builder.

The Java stored procedure is running on a UDB windows NT server. I tested
this on the server and it works fine.
I called this stoproc. from a reporting tool on a client workstation
(crystal reports) and it works fine.
Also, l'm able to connect to the database from VB through ODBC.

But when I called this stored procedure from a Visual basic (using ADO)
client program I'm receiving the following error.

[IBM][CLI driver][DB2/NT] SQL1109N The specified DLL "MEDSP002" could not be
loaded.

MEDSP002 is the name of the stored procedure.

Any help on this will be of great help.

Thanks,
Dominic Raj
DBA
Raytheon Systems Company
(703) 560-5000 Ext : 3465

Dominic Raj

Re: Problem calling Java stoproc from VB
(in response to Dominic Raj)
I haven't received any reply on this problem.

Please reply if you are aware of this problem.

> -----Original Message-----
> From: Raj, Dominic
> Sent: Wednesday, December 15, 1999 2:52 PM
> To: '[login to unmask email]'
> Subject: Problem calling Java stoproc from VB
>
> I've the following problem in running a Java stored procedure called from
> a Visual basic client program.
> The stored procedure was developed using stored procedure builder.
>
> The Java stored procedure is running on a UDB windows NT server. I tested
> this on the server and it works fine.
> I called this stoproc. from a reporting tool on a client workstation
> (crystal reports) and it works fine.
> Also, l'm able to connect to the database from VB through ODBC.
>
> But when I called this stored procedure from a Visual basic (using ADO)
> client program I'm receiving the following error.
>
> [IBM][CLI driver][DB2/NT] SQL1109N The specified DLL "MEDSP002" could not
> be loaded.
>
> MEDSP002 is the name of the stored procedure.
>
> Any help on this will be of great help.
>
> Thanks,
> Dominic Raj
> DBA
> Raytheon Systems Company
> (703) 560-5000 Ext : 3465
>

Steven Camitta

Re: Problem calling Java stoproc from VB
(in response to Dominic Raj)
Raj,
Don't have a good answer but in situations like this I would turn on the
ODBC trace and see if anything unusual comes up. I keep the following coded
in my DB2CLI.INI:

; Comment lines start with a semi-colon.
[COMMON]
;TRACE=1
TRACEPATHNAME=C:\DB2TRACE
TRACEFLUSH=1
TRACECOMM=1

Then when I want to turn the trace on, just uncomment the ;
Your output will appear in the DB2TRACE directory. I've used this a couple
of times to get better insight an interface problem.
HTH,
Steve


-----Original Message-----
From: Raj, Dominic [mailto:[login to unmask email]
Sent: Thursday, December 16, 1999 2:01 PM
To: [login to unmask email]
Subject: Re: Problem calling Java stoproc from VB



I haven't received any reply on this problem.

Please reply if you are aware of this problem.

-----Original Message-----
From: Raj, Dominic
Sent: Wednesday, December 15, 1999 2:52 PM
To: '[login to unmask email]'
Subject: Problem calling Java stoproc from VB

I've the following problem in running a Java stored procedure called
from a Visual basic client program.
The stored procedure was developed using stored procedure builder.

The Java stored procedure is running on a UDB windows NT server. I
tested this on the server and it works fine.
I called this stoproc. from a reporting tool on a client workstation
(crystal reports) and it works fine.
Also, l'm able to connect to the database from VB through ODBC.

But when I called this stored procedure from a Visual basic (using
ADO) client program I'm receiving the following error.

[IBM][CLI driver][DB2/NT] SQL1109N The specified DLL "MEDSP002"
could not be loaded.

MEDSP002 is the name of the stored procedure.

Any help on this will be of great help.

Thanks,
Dominic Raj
DBA
Raytheon Systems Company
(703) 560-5000 Ext : 3465