程序和数据库是我实现的,界面和外观图象是另外一个人实现的.目前在调试阶段,发现一两三天会出现如下问题而导致无法访问数据库,然后等半个小时到一个小时有自动边正常.后来找到一个让出错频繁出现的办法,就是用javascrip反复打开这个页面,大约300-400次后就会出错.网站和数据库的hosting server是用的gadaddy.com,同样的网页在本地的服务器和数据库打开500-600也不会出错(只是我在本地SQL 2000的版本不知道是否和godaddy的相同).有人让我检查程序是否有没有关闭的数据库连接,可是我找了很久都找不到.
System.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. at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at ASP.MyQuery..ctor()
System.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. at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at ASP.MyQuery..ctor()