asp调用存储教程出错,在线等,解决50分相送,ggjj快进来呀
存储过程如下:
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()-------------------------------行33
response.write "success"
%>
报错如下:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
多步 OLE DB 操作产生错误。请检查每个 OLE DB 状态值。没有工作被完成。
/test/text_proc.asp,行33