when I run the following code I get an error. Please help me with a solution. its very very urgent.


With cmdMVS
.ActiveConnection = conMVS
.CommandText = "call MCSTP811(?,?)"
.CommandType = adCmdStoredProc
.Parameters.Append cmdMVS.CreateParameter( "LSINPUT", adChar,
adParamInput, 100, "CERTDAT")
.Parameters.Append cmdMVS.CreateParameter( "LSOUTPUT",
adChar, adParamOutput, 10, "")
.Execute
End With



The error is:

?ERR.Description
No value given for one or more required parameters.

?Err.Number
-2147217904

?err.HelpContext
1000440

?err.HelpFile
C:\WINNT\Help\VBENLR98.CHM

?err.Source
Microsoft OLE DB Provider for ODBC Drivers


Thanks