Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

  Return to Index