解决立刻给分(在线等):多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。这个错误是怎么回事?
存储过程如下:
CREATE PROCEDURE inse
@input_num numeric(9)-- This is the input parameter.
AS
-- Get the sales for the specified title.
insert into example(number) values (@input_num)
asp里调用如下:
<%option explicit%>
<!--METADATA TYPE="TypeLib" uuid="{00000205-0000-0010-8000-00AA006D2EA4}" -->
<%
dim conn,cmd,rs,strconn,input,int_recordcount,out
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=sql;uid=sa;pwd=yyy-hao"
response.write "sql"
conn.Open strconn
set cmd.ActiveConnection=conn
cmd.CommandText="inse"
cmd.commandType=adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("@input_num",adNumeric,adParamInput,9,99129215)
cmd.execute()
response.write "success"
%>