连接数据库错误...救命啊。.....
<form name="form1" method="post" action="check.asp">
<table width="100%" border="0">
<tr>
<td width="26%"> </td>
<td width="74%"><span class="STYLE1">考生登陆</span></td>
</tr>
<tr>
<td align="right">考生姓名:</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td align="right">学 号:</td>
<td><input type="text" name="pass"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form>
<%
'session.timeout=10'session对象的超时值
set conn=server.createobject("adodb.connection") '定义conn为连接数据库连接池
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("exercise.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="Select * from user where user='"& user &"'"
rs.Open sql,conn,1,1
%>
<%if rs.bof then %>
错误类型:
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/1/核对.asp, 第 27 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MyIE2; Embedded Web Browser from: http://bsalsa.com/; InfoPath.2)
网页:
POST 42 ??? /1/核对.asp
POST Data:
user=lxy&passwd=123456&Submit=%CC%E1%BD%BB
时间:
2007年6月3日, 22:08:13