当前位置: 首页 > 图文教程 > 数据库 > MSSQL > SQL Server 2000 SP4与数据链接池问题

MSSQL
SQL Server 压缩日志及数据库文件大小
名词解释：带你轻松接触13个数据库术语
自定义数据库自动编号初始值和步进值
合理设置内存让数据库与其他程序共存
SQL Server 2005：数据类型最大值
数据库手边系列：SQL Server数据表信息
SQL Server讲堂：备份和恢复措施
八个有用的WordPress的SQL语句
SQL Server中链接服务器将替代远程服务器
SQLServer与服务器连接时出错的解决方案
在 SQL Server 数据库开发中的十大问题
SQLServer 游标简介与使用说明
SQLServer 存储过程简介与使用方法
数据库大战： MS SQL Server & IBM DB2
如何了解SQL的执行频率
SQL技巧：快速掌握一些异常精妙的"SQL"语句
经验：解决DB2中出现的SQL1032N错误现象
菜鸟课堂：MySQL权限的详细解答
SQL大讲堂：如何了解SQL的执行频率
扫盲大讲堂：SQL查询结果集对注入的影响及利用

No. « 60 61 62 63 »

技术文章搜索

关键字

MSSQL 中的 SQL Server 2000 SP4与数据链接池问题

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-10-17   浏览: 119 ::
收藏到网摘: n/a

今天远程连接一台xp sp2上的SQL，报错信息如下：

以下为引用的内容：
　　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.
　　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，应该是不可能全部被占用的。

当把链接池设置去掉，就报：

以下为引用的内容：
　　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问题解决，差点被误导。