国产摩托车在非洲:错误类型:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/30 06:42:04
[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误。
/receivedata.asp, 第 8 行

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; TencentTraveler ; .NET CLR 1.1.4322)

网页:
POST 25 ??? /receivedata.asp

POST Data:
usname=aaa&uspassword=123

代码如下:
<%
set conn=server.createobject("Adodb.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("data.mdb")
name=request.form("usname")
pass=request.form("uspassword")
sql="select * from table Where (Name='"&name&"' And Password='"&pass&"')"
set rs=server.createobject("Adodb.recordset")
rs.open sql,conn,3
if rs.eof then
%>
<html>
<head>
<script language="JavaScript">
<!--
function error()
{
alert("Your enter user or password is wrong!");
document.location="login.htm";
}
//-->
</script>
</head>
<body onload="error()">
</body>
</html>
<%
else
sql="insert into chat(Name,content,chattime,chatdate) values('"&name&"','I has enterd chatroom,hi,everyone!'"
sql=sql&",'"&time()&"','"&date()&"')"
rs.open sql,conn,2
%>
<frameset rows="70%,30%">
<frame src="forum.asp" name="main" marginheight="1" marginwidth="1" noresize>
<frame src="frft.asp?kname='<%=Name%>'" name="footnotes" marginwidth="1" marginheight="1" noresize>
</frameset>
<%
end if
%>

请各位高手赐教!

看你前面的提问吧!!