軟件測試開發技術SQL Server 2000 sp4與數據鏈接池問題

軟件測試開發技術SQL Server 2000 sp4與數據鏈接池問題   SQL Server 數據庫

關鍵字：SQL Server 2000 sp4 數據鏈接池

　　今天遠程連接一臺xp sp2上的SQL，報錯信息如下：

　　Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have oclearcase/" target="_blank" >ccurred because all pooled connections were in use and max pool size was reached.

　　Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

　　Exception Details: 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.

　　Source Error:

　　Line 2503: cmd.CommandType = CommandType.StoredProcedure;

　　Line 2504:

　　Line 2505: connection.Open();

　　Line 2506: SqlCommandBuilder.DeriveParameters(cmd);

　　Line 2507: connection.Close();

　　但是，我的連接字符串中已經設置了，最大鏈接池=200，應該是不可能全部被占用的。

　　當把鏈接池設置去掉，就報：

原文轉自：http://www.anti-gravitydesign.com