80分相送,存储过程?
存储过程是这样的:
create prodecure sp_preparation
(@pilot_id varchar(5),@flt_id varchar(5),@flt_date datetime)
as
select preparation,pre_time where pilot_id=@pilot_id and flt_id=@flt_id and flt_date=@flt_date
程序如下:
pilotid="F101"
flt_id="4121"
flt_date=Cdate("2002-11-16")
Set cmd=Server.CreateObject("ADODB.Command")
Set rs0 = Server.CreateObject("ADODB.Recordset")
cmd.ActiveConnection = MM_sqlserver_STRING
cmd.CommandType=4
cmd.CommandText="sp_preparation"
cmd.Parameters.Append cmd.CreateParameter("@pilot_id",200,&H0001,5)
cmd.Parameters.Append cmd.CreateParameter("@flt_id",200,&H0001,5)
cmd.Parameters.Append cmd.CreateParameter("@flt_date",7,&H0001)
cmd.Parameters("@pilot_id")= pilotid
cmd.Parameters("@flt_id")=flt_id
cmd.Parameters("@flt_date")=flt_date
Set rs0=cmd.Execute()
报错:错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
出错行: Set rs0=cmd.Execute()
这是为什么?