错误 '80040e21' .asp调用存储过程发现的一个新问题,求求高手们帮忙啊,救命啊
存储过程
CREATE procedure ds
@num varchar(50)
as
select * from aa where [number]=@num
GO
asp代码
<%
dim conn,rs
set conn=server.createobject("adodb.connection")
conn.connectionstring="driver={sql server};server=CNC-0P4MK7F13AN;uid=liang;pwd=123456;database=cha;"
conn.open
Set cmd = Server.CreateObject("Adodb.Command")
cmd.ActiveConnection = conn
cmd.CommandType = 4
Dim pm1
Set pm1=cmd.CreateParameter("@num",200,1,32)
cmd.Parameters.Append(pm1)
cmd.CommandText = "ds"
cmd("@num") = num
set rs=server.createobject("adodb.recordset")
rs.open cmd,,1,1
rs.close
set rs=nothing
%>
现在提示是:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/cha/zhao.asp,行 38