Question

ADODB.Recordset (0x800A0BB9)参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突

IIS的服务器好麻烦 本身就不太懂计算机这方面 拜托哪位高手帮帮忙 万分感谢～～

错误类型：
ADODB.Recordset (0x800A0BB9)
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/hngct/index.asp, 第 7 行

第 7 行是 “rs.Open sq9,strconn,1,3,8”
具体代码如下：

<%@LANGUAGE="VBSCRIPT" %>
<%
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")

set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sq9,strconn,1,3,8

set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,strconn,1,3,8

set rs1=Server.CreateObject("adodb.recordset")
sql1="SELECT top 12 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs1.Open sql1,strconn,1,3,8

set rs2=Server.CreateObject("adodb.recordset")
sql2="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='2' order by Id desc"
rs2.Open sql2,strconn,1,3,8

set rs3=Server.CreateObject("adodb.recordset")
sql3="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='3' order by Id desc"
rs3.Open sql3,strconn,1,3,8

set rs4=Server.CreateObject("adodb.recordset")
sql4="SELECT top 9 Id,Title,DATE,content FROM tbNews where jjtype='4' order by Id desc"
rs4.Open sql4,strconn,1,3,8

set rs5=Server.CreateObject("adodb.recordset")
sql5="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs5.Open sql5,strconn,1,3,8

set rs7=Server.CreateObject("adodb.recordset")
sql7="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='1' order by Id desc"
rs7.Open sql7,strconn,1,3,8

set rs8=Server.CreateObject("adodb.recordset")
sql8="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='6' order by Id desc"
rs8.Open sql8,strconn,1,3,8

Answer 1

有两处明显的错误:
1.未建立数据库连接;
2.rs的open方法错误;

可以参考以下代码:
<%
'建立数据库连接
set conn=server.createobject("adodb.connection")
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")
conn.open strconn

'建立rs记录集对象
set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sql,conn,1,3

'同样地,建立rs0记录集对象
set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,conn,1,3

'以此类推,rs1到rs8都按以上方法写代码

%>

Answer 2

错误类型：ADODB.Recordset (0x800A0BB9
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突

一般都是SQL语句有错误~~~把SQL输出,然后复制到SQL SERVE查询分析器运行一下...马上就能知道错在那里了