Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
各位大哥，帮下忙了，解决下面这个头痛的问题！！

小弟在此感激不尽.

<%

CurPage=trim(request( "CurPage "))
if CurPage= " " then CurPage=1

dim rs,str
set rs=server.CreateObject( "adodb.recordset ")
rs.Cursortype = 3
rs.pageSize=20
str= "select * from pchome where 1=1 "
if trim(request( "pcname ")) <> " " then
str=str+ " and pcname= ' "&trim(request( "pcname "))& " ' "
url=url+ "&pcname= "&trim(request( "pcname "))
end if
if request( "web ") <> " " then
str=str+ " and web= "&request( "web ")
url=url+ "&web= "&request( "web ")
end if
str=str+ " order by id desc "

rs.open(str),conn,1 （出错的地方就是这一行）

%>

错误信息：

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21 '

ODBC 驱动程序不支持所需的属性。




[解决办法]
你把SQL打出来放到SQL2000的查询分析器里运行,就知道了