|
 |
asp_databases thread: Problem with AS/400, Stored Proc, CA Express...
Message #1 by "Mattias" <mattias.svannel@c...> on Fri, 18 Jan 2002 13:22:58
|
|
Hi there!
I have an Stored Procedure which I call from an ASP page.
The Stored Procedure created on the AS/400 then call on CL program, which
calls on a RPG. I have had this running on one machine, an
NT 4, IIS 4 with Client Access without any problem
But now I have changed to a newer machine, running a 2000, IIS 5 and
Client Access Express V440 SF64474. When I run this, the same code, I
receive this message:
[IBM][Drivrutinen Client Access Express ODBC (32-bitars)][DB2/400 SQL]
SQL0470 - Null values not allowed for parameter 1 in procedure mySP in *N.
This is my code:
Set Comm = server.createobject("ADODB.command")
set Comm.activeconnection = myConn
Comm.Commandtext = "mySP"
Comm.commandtype = 4
Comm.Parameters.refresh
For i = 0 to Comm.parameters.count -1'
Comm.Parameters.Item(I).Type = 129
Next
Comm.Parameters.Item(0) = "myAdmin"
Comm.Parameters.Item(1) = "myComp"
Comm.parameters.Item(2) = "myDiv"
Comm.parameters.Item(3) = "myUserUser" //the person that I would
like to get some information about
Comm.parameters.Item(4) = ""
Comm.Parameters.Item(5) = ""
Comm.parameters.Item(6) = ""
Comm.execute
It "feels" like the parameters are not at any chance excepted and
therefore just cut off. My ideas is that it has something to to with a
communication problems between MDAC or version and SP of Client Access
Express.
On the other hand(just for doing a test) I installed a IIS 5, CA Express
V440 SF64474 on my machine running Windows XP. And here it works.
My MDAC, according to IBM's component checker is 2.0. But if checking
C:/Program files/common/System/ado/ msado15.dll its 2.7.
Thankful for any ideas.
Mattias
|
|
 |