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

MSSQL
如何在把超过固定长度的文字以……表示
精彩的近乎完美的分页存储过程
关于SQL Server SQL语句查询分页数据的解决方案
删除Access数词库中的空记录
在SQLSERVER2005中实现素数计算
经常用到的交叉表问题,一般用动态SQL能生成动态列！
sql server存储过程、存储函数的加密、解密
在SQL Server 2005中查询表结构及索引
取得拼音字头的存储过程
SQL Server自动备份无法删除过期的备份文件
未与信任SQL Server连接相关联的解决方法
小結SQL Server連接失敗錯誤及解決
SQL Server2000+JDBC常见问题及解决
PL/SQL实现Oracle数据库任务调度
Oracle中捕获问题SQL解决CPU过渡消耗
SQL Server 某些条件下求某日的日期
如何保持Oracle数据库的优良性能
SQL Server05 M 3.0 中复制和远程数据访问功能的技术对比
sql server平台用存储过程进行分页的两种方法
sql server 2000中循环插入100万条数据

No. « 84 85 86 87 »

技术文章搜索

关键字

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

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-10-17   浏览: 67 ::
收藏到网摘: 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问题解决，差点被误导。