asp.net页面在VS2005内可以正常访问数据库，而在iis里打开却不能访问，而且没有任何提示

huqingVC 2009-04-15 11:39:59

页面代码很简单，如下：访问的是sql server 2000的northwind数据库

<%@ Page language="C#" %>
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

<script language="C#" runat="server">
void Page_Load()
{
string strConn = "Data Source=HQ;Initial Catalog=Northwind;Integrated Security=True";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = strConn;

string strSql = "Select FirstName, LastName, Country From Employees";
SqlCommand cmd = new SqlCommand(strSql, conn);

string strResult = "";

try
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();

strResult += "<table>";
strResult += "<tr><td>FirstName</td><td>LastName</td><td>Country</td></tr>";
while(dr.Read())
{
strResult += "<tr><td>";
strResult += dr["FirstName"];
strResult += "</td><td>";
strResult += dr["LastName"];
strResult += "</td><td>";
strResult += dr["Country"];
strResult += "</td>";
strResult += "</tr>";
}
strResult += "</table>";

divEmployees.InnerHtml += strResult;
}
catch(Exception e)
{
strResult = "读取数据库时，有错误发生";
}
}
</script>
<HTML>
<BODY>
<div id="divEmployees" runat="server">雇员列表: <br><br></div>
</BODY>
</HTML>

该页面在VS2005里面打开能显示雇员列表下面的内容，而在iis里面打开则只显示雇员列表四个字，下面空白，没有任何错误提示。不知道什么原因。

...全文