多步 OLE DB 操作产生错误。如果可能，请检查每个 OLE DB 状态值。没有工作被完成。

Question

<%
set conn = getconn
set rs = server.CreateObject("adodb.recordset")
strwhere = ""
user=session("Op_ID")
if request("sj_from")<>"" then
sj_from=request("sj_from")
end if
if request("sj_to")<>"" then
sj_to=request("sj_to")
end if
sql ="exec up_count_ck_xx '"&sj_from&"','"&sj_to&"'"
rs.open sql,conn,3,1
%>

提示rs.open sql,conn,3,1 这行

Microsoft OLE DB Provider for SQL Server 错误 '80040e21'

多步 OLE DB 操作产生错误。如果可能，请检查每个 OLE DB 状态值。没有工作被完成。

请高手帮忙

Answer 1

使用ADODB.Command来执行存储过程，recordset对象不支持参数，所以会报错。

以下是MSDN中查到的错误信息描述
PSS ID Number: Q214459
Article Last Modified on 08-23-2001
--------------------------------------------------------------------------------
The information in this article applies to:
ActiveX Data Objects (ADO) 2.0, 2.1 SP2, 2.5, 2.6, 2.7
--------------------------------------------------------------------------------
Summary
When you use ActiveX Data Objects (ADO) to pass parameters to a stored procedure, you may receive the following error:

Run-time error '2147217887 (80040e21)':
[Microsoft][ODBC SQL Server Driver] Optional Feature Not Implemented.

More Information
This error can occur if you attempt to set the TYPE of a parameter in an ADODB command object's parameters collection to a type that is not supported by the data provider.