关于ASP调取mdb数据库数据
<table border="1" cellspacing="0" cellpadding="0" class="table" width="100%" style="white-space:nowrap"><tr>
<td width="80" align="center">序号</td>
<td width="100px" align="center">任务编号</td>
<td width="150px" align="center">状态</td>
<td width="100px" align="center">投产日期</td>
<td width="100px" align="center">交付日期</td>
<td width="600px" align="center">
<form name="kh" id="kh">
<select name="menu1" onchange="MM_jumpMenu('mainFrame',this,0)" style="border:none; ">
<option style="text-align:center">客户名称</option>
</select>
</form>
</td>
<td width="200px" align="center">产品名称</td>
<td width="200px" align="center">产品型号</td>
<td width="80px" align="center">单位</td>
<td width="100px" align="center">数量</td>
<td width="150px" align="center">清单</td>
<td width="100px" align="center">合同编号</td>
<td width="150px" align="center">合同内容</td>
<td width="150px" align="center">报价金额</td>
<td width="150px" align="center">合同金额</td>
<td width="150px" align="center">开票金额</td>
<td width="150px" align="center">已付金额</td>
<td width="400px" align="center">备注</td>
<td width="80px" align="center" style="border:none"> </td>
<td width="80px" align="center" style="border:none"> </td>
</tr>
<%
for i=1 to rsc.recordcount step 1
%>
<tr>
<td align="center"><%=i%></td>
<td align="center"><%=rsc("rwbh")%></td>
<td align="center"><%=rsc("zt")%></td>
<td align="center"><%=rsc("tcrq")%></td>
<td align="center"><%=rsc("jfrq")%></td>
<td align="center"><%=rsc("khmc")%></td>
<td align="center"><%=rsc("cp")%></td>
<td align="center"><%=rsc("xh")%></td>
<td align="center"><%=rsc("dw")%></td>
<td align="center"><%=formatnumber(rsc("sl"),2)%></td>
<td align="center">
<%
if rsc("qd")="详见明细" then
response.Write"<a href=../qd/" & rsc("rwbh") & ".pdf target=_blank>" & rsc("qd") & "</a>"
else
response.Write"无"
end if
%>
</td>
<td align="center"><%=rsc("htbh")%></td>
<td align="center"><a href="../qd/<%=rsc("rwbh")%>.pdf" target="_blank"><%=rsc("htnr")%></a></td>
<td align="center"><%=formatnumber(rsc("bjje"),2,-1)%></td>
<td align="center"><%=formatnumber(rsc("htje"),2,-1)%></td>
<td align="center">
<%
set rs=server.createobject("adodb.recordset")
sql="select sum(kpje) as kp from kpmx where rwbh='" & rsc("rwbh") & "'"
rs.open sql,conn,1,1
response.write "<a href=kpcx.asp?n=" & rsc("rwbh") & "> " & formatnumber(rs("kp"),2,-1) & "</a>"
rs.close
%>
</td>
<td align="center">
<%
set rs=server.createobject("adodb.recordset")
sql="select sum(dkje) as dk from dkmx where rwbh='" & rsc("rwbh") & "'"
rs.open sql,conn,1,1
response.write "<a href=dkcx.asp?n=" & rsc("rwbh") & "> " & formatnumber(rs("dk"),2,-1) & "</a>"
rs.close
%>
</td>
<td><%=rsc("bz")%></td>
<td width="80px" align="center" style="border:none"><a href="#">更改</a></td>
<td width="80px" align="center" style="border:none"><a href="#">删除</a></td>
</tr>
<%
rsc.movenext
next
%>
</table>
这段代码,我在下载的简易服务器测试没有问题,可以调出数据。可是在win7下安装了IIS7.5,然后进行测试这里就读不出数据,请问大神们这是什么问题呢?谢谢!!