asp密码修改问题
点击修改密码出现以下错误;Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/cx/newpasss.asp，行 8
NEWPASS.ASP代码
<!--#include file=conn.asp-->
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sfzh=session("Sfzh")
passwd=session("Passwd")
sql="select * from admin1 where sfzh='"&Sfzh&"'and passwd='"&Passwd&"'"
rs.open sql,conn,3,3
if rs.eof then (错误行）
response.redirect "index.asp"
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css">
<title>修改密码</title>
<script language="JavaScript">
<!--
function checkdata() {
if( form.jpass.value =="") {
alert("\请输入旧密码")
return false;
}
if( form.pass.value =="") {
alert("\请输入新密码")
return false;
}
return true;
}
function isNumberString (InString,RefString)
{
if(InString.length==0) return (false);
for (Count=0; Count < InString.length; Count++) {
TempChar= InString.substring (Count, Count+1);
if (RefString.indexOf (TempChar, 0)==-1)
return (false);
}
return (true);
}
// -->
</script>
</head>
<body leftmargin="0" Topmargin="0" marginwidth="0" marginheight="0" background="images/greystrip.gIf">
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr><td><div align="right"><a href="index.asp"><font color="red">返回首页</font></a> </div></td></tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" vspace="0" hspace="0" bordercolordark="#FFFFFF" bordercolorlight="#316395" height="35">
<tr>
<td></td>
</tr>
</table>
<form method="POST" name=form action="newpasss.asp?sfzh1=<%response.write sfzh%>" style="font-family: ??ì?; font-size: 12px; margin-top: 0pt; margin-bottom: 0pt" onSubmit="return checkdata()">
<table width="60%" height="31" border="0" align="center" cellpadding="0" bordercolor="#111111" id="Autonumber3" style="border-collapse: collapse">
<tr>
<td>旧密码：
<input type="password" name="jpass" size="16" class="smallinput" maxlength="255" style="border:1px solid #CCCCCC; width:100;height:18; color:#444444; font-size:9pt; background-color:#F4F4F4" onMouseOver="style.backgroundColor='#FFFFFF'" onmouseout="style.backgroundColor='#F4F4F4'">
新密码：
<input type="password" name="pass" size="16" class="smallinput" maxlength="255" style="border:1px solid #CCCCCC; width:100;height:18; color:#444444; font-size:9pt; background-color:#F4F4F4" onMouseOver="style.backgroundColor='#FFFFFF'" onmouseout="style.backgroundColor='#F4F4F4'"> <input type="submit" value="提交" name="B1">
<input type="reset" value="重写" name="B2"> </td>
</tr><tr><td> :<br>
<font color="#FF0000">温馨提示：系统初始密码为111111，请输入六位数的数字或字母（不能含空格和中文）进行修改！</font><br>
<br><br></td></tr>
</table>
</form>
</body>
</html>
<!--#include file="bottom.asp"-->
CONN.ASP代码
<%
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("data/gjj.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
%>
请高手们帮忙解决一下
[ 本帖最后由 cravexp 于 2012-6-6 07:30 编辑 ]
