关于存储过程的问题,什么叫没有执行可选特性呢??
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
[Microsoft][ODBC SQL Server Driver]没有执行可选特性
/corporation/info_view_r.asp, 第 79 行
79行代码就是执行了
部分代码
*************************************************************
set cmd=server.CreateObject("adodb.command")
set cmd.ActiveConnection=conn
cmd.CommandText = "ado.info_view" '存储过程名称
cmd.CommandType = 4
cmd.Parameters.Append cmd.CreateParameter("@info_kind",AdVarChar,adParaminput,8)
cmd.Parameters.Append cmd.CreateParameter("@area_id",adtinyint,adParamInput)
cmd.Parameters.Append cmd.CreateParameter("@place_id",AdSmallInt,adParamInput)
cmd.Parameters.Append cmd.CreateParameter("@result",AdVarChar,adParaminput,10)
cmd.Parameters.Append cmd.CreateParameter("@time1",addate,adParaminput)
cmd.Parameters.Append cmd.CreateParameter("@time2",addate,adParaminput)
cmd.Parameters.Append cmd.CreateParameter("@id",AdInteger,adParaminput)
cmd.Parameters.Append cmd.CreateParameter("@out",AdVarChar,adParamOutput,300)
cmd.Parameters.Append cmd.CreateParameter("@out2",AdVarChar,adParamOutput,300)
'输出参数
cmd("@info_kind")=info_kind
cmd("@area_id")=area_id
cmd("@result")=result
cmd("@time1")=time1
cmd("@time2")=time2
cmd("@id")=session("m_id")
cmd.Execute() *************这里出错*************
out=cmd("@out")
out2=cmd("@out2")
*****************************************************************