救急,Timeout expired.Timeout expired. 救急
pmmx 2006-06-07 11:32:06 错误信息:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
---------------------------
[InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.]
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
OKOO.SQLServerDAL.DbHelperSQL.RunProcedure(String storedProcName, IDataParameter[] parameters) in D:\OKOO\SQLServerDAL\DbBasic.cs:446
OKOO.SQLServerDAL.KO_Article.GetTopic(String classid, String topx) in D:\OKOO\SQLServerDAL\Article.cs:31
OKOO.BLL.KO_Article.GetTopic(String classid, String topx) in D:\OKOO\BLL\Article.cs:93
OKOO.Web.Control.ListNews.reader(String id, String num, Int32 style) in D:\OKOO\Web\Control\ListNews.ascx.cs:49
OKOO.Web.Control.ListNews.Page_Load(Object sender, EventArgs e) in D:\OKOO\Web\Control\ListNews.ascx.cs:22
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731
本地调试没有问题,放服务器上一段时间之后,大概几十个访问量之后出现问题
web.config里数据库连接配置:
<add key="DAL" value="OKOO.SQLServerDAL" />
<add key="ConnectionString" value="server=.;uid=sa;pwd=sa;database=okoodb" />
数据库层代码:
public SqlDataReader GetTopic(string classid,string topx)
{
SqlParameter[] parameters = {
new SqlParameter("@ClassID",System.Data.SqlDbType.VarChar,255),
new SqlParameter("@Topx",System.Data.SqlDbType.VarChar,255)
};
parameters[0].Value = classid;
parameters[1].Value = topx;
SqlDataReader dr =DbHelperSQL.RunProcedure("UP_KO_Article_GetTopic",parameters);
return dr;
}
显示层:
private void reader(string id ,string num,int style)
{
BLL.KO_Article bll = new OKOO.BLL.KO_Article();
SqlDataReader dr = bll.GetTopic(id,num);
this.stylestr=null;
while(dr.Read())
{
this.stylestr=this.stylestr+"<a href="+"Class"+dr["ClassID"].ToString()+"/"+dr["ArticleID"].ToString()+".html"+">"+dr["title"].ToString()+"</a><br />";
}
}
几十个访问量之后就出现Timeout expired
谢谢.