当把链接池设置去掉,就报:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
Line 2503: cmd.CommandType = CommandType.StoredProcedure;
Line 2504:
Line 2505: connection.Open();
Line 2506: SqlCommandBuilder.DeriveParameters(cmd);
Line 2507: connection.Close();
这下子,问题就明朗了,典型的没有打 Sql2000 sp4 的问题,打上sp4问题解决,差点被误导
文章来源于领测软件测试网 https://www.ltesting.net/