[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x4c8 Thread 0x5a0 DBC 0x146b024 Jet'。

/wt/hunxian.asp，行 83

关键代码如下:

<!-- #include file="../wt/conn.asp" -->
<%
set rs=server.CreateObject("adodb.recordest") '第83行
set rs=conn.execute("seleect*from info")
%>

<tr>
<td width="75"><img src="images/class_r5_c5.jpg" width="75" height="34"></td>
<td width="657" background="images/class_r5_c7.jpg"><font color="#FF66CC">所有会员</font></td>
<td width="15"><img src="images/class_r5_c9.jpg" width="15" height="34"></td>
</tr>
<tr valign="top">
<td height="406" colspan="3" class="unnamed3"><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="84" height="28"> <div align="center">用户名</div></td>
<td width="76"><div align="center">密码</div></td>
<td width="77"> <div align="center">姓名</div></td>
<td width="70"><div align="center">QQ</div></td>
<td width="86"><div align="center">邮箱</div></td>
<td width="79"><div align="center">地址</div></td>
<td width="79"> <div align="center">单位</div></td>
<td width="85"><div align="center">电话</div></td>
<td width="89"> <div align="center">手机</div></td>
</tr>
<tr> <% do while not(rs.eof or err) %>
<td height="30"><%=rs("username")%></td>
<td><%=rs("password")%></td>
<td><%=rs("hh")%></td>
<td><%=rs("qq")%></td>
<td><%=rs("mail")%></td>
<td><%=rs("adders")%></td>
<td><%=rs("dw")%></td>
<td><%=rs("tel1")%></td>
<td><%=rs("tel2")%></td>
<%
rs.movenext
loop
%>
<%
dim page_size
dim page_no
dim page_total
dim wenjianming
wenjianming="a.asp"
page_size=10
if request.querystring("page_no")="" then
page_no=1
else
page_no=cint(request.querystring("page_no"))
end if
rs.pagesize=page_size
page_total=rs.pagecount
if not(rs.bof or rs.eof) then
rs.absolutepage=page_no
end if
dim i
i=page_size
%>

<%
if page_total=1 then
response.write "首页|上一页|下一页|尾页"
else
response.write "<a href=" & wenjianming & "?page_no=1>首页</a>|"
if page_no-1>0 then
response.write "<a href=" & wenjianming & "?page_no=" & page_no-1 & ">上一页</a>|"
else
response.write "上一页|"
end if
if page_no+1<=page_total then
response.write "<a href=" & wenjianming & "?page_no=" & page_no+1 & ">下一页</a>|"
else
response.write "下一页|"
end if
response.write "<a href=" & wenjianming & "?page_no=" & page_total & ">尾页</a>"
end if
%>

[Microsoft][ODBC Microsoft Access Driver] 无效的 SQL语句；期待 'DELETE'、'INSERT'、'PROCEDURE'、'SELECT'、或 'UPDATE'。

/wt/hunxian.asp，行 84
关键代码如下:
<!-- #include file="../wt/conn.asp" -->
<%
set rs=server.CreateObject("adodb.recordset") '第83行
set rs=conn.execute("seleect*from info") '第84行
%>

<tr>
<td width="75"><img src="images/class_r5_c5.jpg" width="75" height="34"></td>
<td width="657" background="images/class_r5_c7.jpg"><font color="#FF66CC">所有会员</font></td>
<td width="15"><img src="images/class_r5_c9.jpg" width="15" height="34"></td>
</tr>
<tr valign="top">
<td height="406" colspan="3" class="unnamed3"><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="84" height="28"> <div align="center">用户名</div></td>
<td width="76"><div align="center">密码</div></td>
<td width="77"> <div align="center">姓名</div></td>
<td width="70"><div align="center">QQ</div></td>
<td width="86"><div align="center">邮箱</div></td>
<td width="79"><div align="center">地址</div></td>
<td width="79"> <div align="center">单位</div></td>
<td width="85"><div align="center">电话</div></td>
<td width="89"> <div align="center">手机</div></td>
</tr>
<tr> <% do while not(rs.eof or err) %>
<td height="30"><%=rs("username")%></td>
<td><%=rs("password")%></td>
<td><%=rs("hh")%></td>
<td><%=rs("qq")%></td>
<td><%=rs("mail")%></td>
<td><%=rs("adders")%></td>
<td><%=rs("dw")%></td>
<td><%=rs("tel1")%></td>
<td><%=rs("tel2")%></td>
<%
rs.movenext
loop
%>
<%
dim page_size
dim page_no
dim page_total
dim wenjianming
wenjianming="a.asp"
page_size=10
if request.querystring("page_no")="" then
page_no=1
else
page_no=cint(request.querystring("page_no"))
end if
rs.pagesize=page_size
page_total=rs.pagecount
if not(rs.bof or rs.eof) then
rs.absolutepage=page_no
end if
dim i
i=page_size
%>

还是有问题呀
当用户名,密码全对时,登陆成功
当用户名对,密码不对时,会提示"密码错误"
但用户名不对时.就出现错误了:

错误 '80020009'

/wt/checkhun.asp，行 17

checkhun.asp

<!-- #include file="conn.asp" -->
<%
username=request("username")
password=request("password")
set rs=server.CreateObject("adodb.recordset")
sql="select * from info where username='"&username&"'"
rs.open sql,conn,1,1
if not (rs.bof and eof) then
if password=rs("password") then '行17
session("arteah")=request("username")
session("id")=rs("id")
response.write("<script>alert('登陆成功');history.back();</script>")
else
response.write("<script>alert('密码错误,请重新输入');history.back();</script>")
end if
else
response.write("<script>alert('用户不存,请确定后再输入');history.back();</script>")
end if
%>

[此贴子已经被作者于2006-2-18 9:05:34编辑过]

这个问题有人帮我解决一下吗??

当用户名,密码全对时,登陆成功
当用户名对,密码不对时,会提示"密码错误"
但用户名不对时.就出现错误了:

错误 '80020009'

/wt/checkhun.asp，行 17

checkhun.asp

<!-- #include file="conn.asp" -->
<%
username=request("username")
password=request("password")
set rs=server.CreateObject("adodb.recordset")
sql="select * from info where username='"&username&"'"
rs.open sql,conn,1,1
if not (rs.bof and eof) then
if password=rs("password") then '行17
session("arteah")=request("username")
session("id")=rs("id")
response.write("<script>alert('登陆成功');history.back();</script>")
else
response.write("<script>alert('密码错误,请重新输入');history.back();</script>")
end if
else
response.write("<script>alert('用户不存,请确定后再输入');history.back();</script>")
end if
%>

现在对了,难倒不能有and连写??还非得和VB一样麻烦?