存储过程出错,帮忙看看。
存储过程出错,给几个输入参数,让存储过程得出输出参数。
<!--#include virtual="/inc/Link_Db.asp"-->
<!--#include virtual="/inc/adovbs.inc"-->
<%
Set cmdTest = Server.CreateObject("ADODB.Command")
cmdTest.ActiveConnection = Conn
cmdTest.CommandText = "存储过程名"
cmdTest.CommandType = adCmdStoredProc
'-------------------InPut 输入参数
cmdTest.Parameters.Append cmdTest.CreateParameter("@编报行id",adInteger,adParamInput,,Session("usrBankid"))
cmdTest.Parameters.Append cmdTest.CreateParameter("a1",adVarChar,adParamInput,20,"1")
cmdTest.Parameters.Append cmdTest.CreateParameter("a2",adDBDate,adParamInput,,"2002-7-1")
cmdTest.Parameters.Append cmdTest.CreateParameter("a3",adVarChar,adParamInput,20,"5")
cmdTest.Parameters.Append cmdTest.CreateParameter("a4",adVarChar,adParamInput,20,"8")
cmdTest.Parameters.Append cmdTest.CreateParameter("a5",adInteger,adParamInput,,"10")
'-------------- Output 输出参数
cmdTest.Parameters.Append cmdTest.CreateParameter("Output1",adInteger,adParamOutput)
cmdTest.Parameters.Append cmdTest.CreateParameter("Output2",adNumeric,adParamOutput)
cmdTest.Execute
'----这里出错:Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)