Question

ADODB.Recordset 错误 '800a0bb9'

ADODB.Recordset 错误 '800a0bb9'

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

/login.asp，行 6

代码：
conn.asp文件
<%
var MM_conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.Mappath("db/db.mdb")
%>

longin.asp文件
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
var login = Server.CreateObject("ADODB.Recordset");
login.ActiveConnection = MM_conn_STRING;
login.Source = "SELECT * FROM user";
login.CursorType = 0;
login.CursorLocation = 2;
login.LockType = 1;
login.Open();
var login_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Server.HTMLEncode(Request.QueryString);
var MM_valUsername=String(Request.Form("nid"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="msearch.asp";
var MM_redirectLoginFailed="bmok.html";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_conn_STRING;
MM_rsUser.Source = "SELECT nid, psw";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM user WHERE nid='" + MM_valUsername.replace(/'/g, "''") + "' AND psw='" + String(Request.Form("psw")).replace(/'/g, "''") + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
在本机运行一切正常，上传到服务器后改了相对路径就不行了~~

召唤JS达人啊

Answer 1

楼主,出现ADODB.Recordset 错误 '800a0bb9'
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
只有两种情况:
第一种情况是没有调用数据库连接页面,比如<!--#include file="conn.asp"-->
第二种情况是查询条件下,没有判断if rslist.eof then这种情况
if rslist.eof then
response.redirect"需要导入的文件.asp"
end if

'800a03ec'解决方法
可能你的IIS使用Jscript作为你的默认脚本语言了，显式声明一下：

<%@ LANGUAGE=VBSCRIPT %>
<%
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("../database/sanhe_data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
function changechr(str)
changechr=replace(replace(replace(str,"<","<"),">",">"),chr(13),"<br>")
response.write changechr
end function

function changechr1(str)
changechr1=replace(replace(replace(str,"<","<"),">",">"),"<br>",chr(13))
response.write changechr1
end function

晕晕,怎么又换了....
换个机器拖吧

Answer 2

先打开数据库试试

var conn=server.createobject("ADODB.connection");
conn.open(MM_conn_STRING);

Answer 3

conn.asp文件
<%
on error resume next
var MM_conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.Mappath("db/db.mdb")
set MM_conn_STRING =server.createobject("ADODB.CONNECTION")
%>
再试试。。。

Answer 4

ADODB.Recordset 错误 '800a0bb9'

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
'==============================================================
出现上述错误的原因:
1.楼主在ASP纲页文件中,运用了ASP保留字user(login.Source = "SELECT * FROM user";
),把db资料库中表的user表名,换为其它名称试试.
2.资料库中是否有满足条件的资料,若没有也会显示这样的错误提示.
3.是否正确调用资料库连接的代码(查看路径及代码)