用logic教编曲:[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。到底我的哪个代码错了？

来源：百度文库 编辑：高考问答 时间：2024/05/04 19:55:39
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<!-- #include file="Connections/conn.asp" --> <!--包含数据库连接文件-->
<% session.Timeout=120
if request.Form("UserName")<>"" and request.Form("PWD")<>"" then
session("UserName")=request.Form("UserName")
session("PWD")=request.Form("PWD")
sql="select UserName,PWD from DB_manager where name='" & session("UserName")&"'"
set rs=conn.execute(sql)
if rs.eof then %>
<script language="javascript">
alert("您输入的管理员名称错误，请重新输入！");
</script>
<% else
if rs("PWD")=session("PWD") then %>
<script language="javascript">
window.location.href="manager/default.asp"
</script>
<%else%>
<script language="javascript">
alert("您输入的管理员密码错误，请重新输入！");
history.back();
</script>
<%end if
end if
end if
%>
<script language="JavaScript">
function mysubmit(){
if (form1.userID.value=="")
{alert("请输入用户名");form1.userID.focus();return false;}
if (form1.userPWD.value=="")
{alert("请输入密码");form1.userPWD.focus();return false;}
//form1.submit();
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>

<body>
<div align="center">
<form name="form1" method="post" action="index.asp">
<table width="350" border="0">
<tr>
<td width="344"><div align="center">＝＝＝＝＝管理员登录＝＝＝＝＝</div></td>
</tr>
<tr>
<td><div align="center">用户名：
<input name="UserName" type="text" id="UserName" size="11">
</div></td>
</tr>
<tr>
<td><div align="center">密码：
<input name="PWD" type="password" class="Style_button" id="PWD" size="11">
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="Landing" type="submit" id="Landing" value="登陆"onClick="return mysubmit()">

<input name="Register" type="submit" id="Register" onClick="MM_openBrWindow('agent.asp','','')" value="注册">
</div></td>
</tr>
</table>
</form>
</div>
</body>
</html>
数据库名为Customer.mdb
表名为DB_manager
字段名为：UserName,PWD
单击登陆按钮时屏幕提示为：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/houtai/index.asp, 第 9 行

帮个忙啊，我写的那个代码错了？

应该把这段
<% session.Timeout=120
if request.Form("UserName")<>"" and request.Form("PWD")<>"" then
session("UserName")=request.Form("UserName")
session("PWD")=request.Form("PWD")
sql="select UserName,PWD from DB_manager where name='" & session("UserName")&"'"
set rs=conn.execute(sql)
if rs.eof then %>
写在
<script language="JavaScript">
function mysubmit(){
if (form1.userID.value=="")
{alert("请输入用户名");form1.userID.focus();return false;}
if (form1.userPWD.value=="")
{alert("请输入密码");form1.userPWD.focus();return false;}
//form1.submit();
}
</script>
的后面

[Microsoft][ODBC [Microsoft][ODBC Microsoft Access Driver]常见错误 [Microsoft][ODBC Microsoft Access Driver] 内存溢出 [Microsoft][ODBC Microsoft Access Driver] 内存溢出 ODBC数据源管理器中无microsoft odbc for oracle Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] ？ Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] ？ Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'[Microsoft][ODBC Microsoft Access Driver] [microsoft][odbc microsoft access driver]参数不足,期待是1