帮我看看ASP程序哪里写错了

来源:百度知道 编辑:UC知道 时间:2024/05/30 14:35:13
conn.asp ‘连接数据库并打开表
<%
dim sjk
dim sjkconn
sjkconnstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("db1.mdb")
set sjk=server.createobject("ADODB.CONNECTION")
sjk.open sjkconnstr
%>
<%
set rs=Server.CreateObject("ADODB.recordset")
rs.open "select * from dubin",sjk,1,1
%>

show.asp '显示表里的内容
<!--#include file="conn.asp"-->
<%
if rs.EOF and rs.BOF the
response.write("完毕")
else
Do Until rs.EOF
response.write(rs.("bh"))
response.write(rs.("zm"))
response.write(rs.("je"))
rs.MoveNext
loop
end.if
%>
<%rs.close
set sjk=Nothing
%>

iis7以前会提示哪一行错了,现在没有提示。。只是说程序错误,我也不知道哪错了
不是程序问题,可能是vista系统中iis7配置出现问题了..会的帮帮忙,谢谢~~~~~~~~~

<%
dim sjk
dim sjkconn
sjkconnstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("db1.mdb")
set sjk=server.createobject("ADODB.CONNECTION")
sjk.open sjkconnstr
%>

show.asp '显示表里的内容
<!--#include file="conn.asp"-->
<%
set rs=Server.CreateObject("ADODB.recordset")
rs.open "select * from dubin",sjk,1,1
if rs.EOF and rs.BOF then
response.write("完毕")
else
Do while not rs.EOF
response.write(rs.("bh"))
response.write(rs.("zm"))
response.write(rs.("je"))
rs.MoveNext
loop
end.if
rs.close
set rs=Nothing
sjk.close
set sjk=nothing
%>

if rs.EOF and rs.BOF the
response.write("完毕")

--------------------
if rs.EOF and rs.BOF then
response.write("完毕")

<