调用存储过程出错,谁帮忙看看啊
存储过程如下:
Alter Procedure [dbo].Source_add
(
@cpname varchar(200),--产品名称
@guige varchar(200),--产品规格
@danwei char(30),--产品单位
@price float,--产品单价
@shuliang int,--产品数量
@owner varchar(200),--供货商
@jhdate datetime,--进货日期
@remark text --备注
)
As
SET NOCOUNT ON
Begin
Insert Into [dbo].Source
(cpname,guige,danwei,price,shuliang,owner,jhdate,remark)
Values
(@cpname,@guige,@danwei,@price,@shuliang,@owner,@jhdate,@remark)
End
SET NOCOUNT OFF
调用页面:
owner=Getvalue( "owner ",1)
cpname=Getvalue( "cpname ",1)
guige=Getvalue( "guige ",0)
danwei=Getvalue( "danwei ",1)
price=Getvalue( "price ",1)
shuliang=Getvalue( "shuliang ",1)
remark=Getvalue( "remark ",0)
jhdate=Getvalue( "jhdate ",1)
Set cmd=Server.CreateObject( "ADODB.Command ")
With cmd
.CommandType = adCmdStoredProc
.CommandText = "Source_add "
With .Parameters
.Append cmd.CreateParameter( "strcpname ",adVarChar,adParamInput,200,cpname)
.Append cmd.CreateParameter( "strguige ",adVarChar,adParamInput,200,guige)
.Append cmd.CreateParameter( "strdanwei ",adVarChar,adParamInput,30,danwei)
.Append cmd.CreateParameter( "strprice ",adInteger,adParamInput,,price)
.Append cmd.CreateParameter( "strshuliang ",adInteger,adParamInput,,shuliang)
.Append cmd.CreateParameter( "strowner ",adVarChar,adParamInput,200,owner)
.Append cmd.CreateParameter( "strjhdate ",adDate,adParamInput,,jhdate)
.Append cmd.CreateParameter( "strremark ",adLongVarChar,adParamInput,1024*300,remark)
End With
.ActiveConnection = conn
.Execute,,adExecuteNoRecords
End With
Response.Redirect "Source.asp "
Set cmd=Nothing
Closeconn
提示“.Execute,,adExecuteNoRecords”这行出错
出错提示“
Microsoft OLE DB Provider for ODBC Drivers错误 '80040e21 '
[Microsoft][ODBC SQL Server Driver]没有执行可选特性
/xyjd/www/Source_add_save.asp,行 29
”
------解决方案--------------------直接 .Execute 删除后面的试试.
------解决方案--------------------.Execute,,adExecuteNoRecords
修改成 .Execute看看
------解决方案--------------------Alter Procedure [dbo].Source_add
应该是Create Procedure [dbo]