紧急问题!有关存储过程!
请帮我看看这段代码,有什么问题!
该存储过程我在SQL的查询分析器下施行没有问题,可一用Command调用,就出现问题,好像不施行存储过程。
//==================
参数不会有问题,我都测试过
报错为:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
/users/add.asp,行135
=================================
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="dsn=bgqc"
conn.open
set com=server.CreateObject("ADODB.Command")
com.ActiveConnection=conn
com.CommandText="commonuser_add"
com.CommandType=adCmdStoredProc
'--------------------------------------------------------创建参数
com.Parameters.Append com.CreateParameter("@username",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@realname",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@userright",adTinyInt,adParamInput,1)
com.Parameters.Append com.CreateParameter("@password",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@gender",adChar,adParamInput,2)
com.Parameters.Append com.CreateParameter("@email",adChar,adParamInput,20)
com.Parameters.Append com.CreateParameter("@province",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@city",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@address",adChar,adParamInput,80)
com.Parameters.Append com.CreateParameter("@zip",adChar,adParamInput,6)
com.Parameters.Append com.CreateParameter("@idno",adChar,adParamInput,18)
com.Parameters.Append com.CreateParameter("@hometel",adChar,adParamInput,15)
com.Parameters.Append com.CreateParameter("@worktel",adChar,adParamInput,20)
com.Parameters.Append com.CreateParameter("@cell",adChar,adParamInput,15)
com.Parameters.Append com.CreateParameter("@industry",adChar,adParamInput,20)
com.Parameters.Append com.CreateParameter("@occupation",adChar,adParamInput,20)
com.Parameters.Append com.CreateParameter("@income",adChar,adParamInput,10)
com.Parameters.Append com.CreateParameter("@logoncount",adInteger,adParamInput,4)
com.Parameters.Append com.CreateParameter("@logintime",adDate,adParamInput,8)
com.Parameters.Append com.CreateParameter("@ip",adChar,adParamInput,16)
com.Parameters.Append com.CreateParameter("@isip",adTinyInt,adParamInput,1)
com.Parameters.Append com.CreateParameter("@isuser",adTinyInt,adParamInput,1)
''--------------------------------------------------------------------------------------------------------------
com("@username")=mname
com("@realname")=mrealname
com("@userright")=muserright
com("@password")=mpassword
com("@gender")=mgender
com("@email")=memail
com("@province")=mprovince
com("@city")=mcity
com("@address")=maddress
com("@zip")=mzip
com("@idno")=midno
com("@hometel")=mhometel
com("@worktel")=mworktel
com("@cell")=mcell
com("@industry")=mindustry
com("@occupation")=moccupation
com("@income")=mincome
com("@logoncount")=mlogoncount
com("@logintime")=mlogintime
com("@ip")=mip
com("@isip")=misip
com("@isuser")=misuser
com.Execute //行135
==================================
报错为:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
/users/add.asp,行135
=======================================
存储过程是:
CREATE PROCEDURE commonuser_add
(
@username char(10),
@realname char(10),
@userright tinyint,
@password char(10),
@gender char(2),
@email char(20),
@province char(10),
@city char(10),
@address char(80),
@zip char(6),
@idno char(18),
@hometel char(15),
@worktel char(20),
@cell char(15),
@industry char(20),
@occupation char(20),
@income char(10),
@logoncount int,
@logintime datetime,
@ip char(16),
@isip tinyint,
@isuser tinyint
)
AS
INSERT commonuser
(username,realname,userright,password,gender,email,province,city,address,zip,idno,hometel,worktel,cell,industry,occupation,income,logoncount,logintime,ip,isip,isuser)
values
(@username,@realname,@userright,@password,@gender,@email,@province,@city,@address,@zip,@idno,@hometel,@worktel,@cell,@industry,@occupation,@income,@logoncount,@logintime,@ip,@isip,@isuser)
GO