我是新手，咨询一个登录的问题？

9805034 2003-10-20 01:04:23

我在登录界面中输入口令和密码后进入不了第二个页面，提示为：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>

...全文

75 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

dafei0320 2003-10-20

打赏
举报

是数据库读取错了！！
最好不要用+，用&
user="driver={microsoft access driver(*.mdb)};DBQ="+server.mappath("user.mdb")
还要set rs = server.createobject("adodb.recordset")

lovehwq21 2003-10-20

打赏
举报

user="DBQ="+server.mappath("user.mdb")+";driver={microsoft access driver(*.mdb)};"
换成这种写法
user="driver={microsoft access driver(*.mdb)};DBQ="+server.mappath("user.mdb")
还要set rs = server.createobject("adodb.recordset")
把conn.execute(sql)这句也去掉好了