我是新手,咨询一个登录的问题?
我在登录界面中输入口令和密码后进入不了第二个页面,提示为:microsoft ole db provider for odbc drivers(0x80004005),请高手帮我看看代码,不胜感激!
<% @ language=vbscript %>
<% dim uid,upassword
uid=request.form("uid")
upassword=request.form("upassword")
Set conn=Server.CreateObject("adodb.Connection")
user="DBQ="+server.mappath("user.mdb")+";driver={microsoft access driver(*.mdb)};"
conn.open user
sql="select * from user where (uid='"+uid+"'and upassword='"+upassword+"')"
conn.execute(sql)
set RS= conn.execute(sql)
conn.close
set conn=nothing
%>
<%if NOT RS.EOF then%>
<% session("uid")=uid%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body background="b093.gif" alink="red" vlink="green">
<table border="0" cellspacing="1" width="65%" height="208" align=center>
<tr>
<td width="100%" height="41" align=center>
<strong><big><font color="#FF8040" size="4">
恭喜!你是合法用户,欢迎光临指教!
</font></big></strong>
</td>
</tr>
<tr>
<td width="100%" height="90" align=center>
<hr>
</td>
</tr>
<tr>
<td width="100%" height="65" align=center>
<a herf="main.htm" border="0" >进入主页面</a>
</td>
</tr>
</table>
</body>
</HTML>