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

MSSQL
MS-sql 2005拒绝了对对象 ''xxx'' (数据库 ''xxx''，架构 ''dbo'')的 SELECT 权限的解决方法
MSSQL 2005 LOG备份webshell的方法
快速将珊瑚虫IP数据库转MS SQL2005的图文教程
sql2005 远程连接问题解决方法
SQLServer 2005 列所有存储过程的语句
SQL Server 2005 模板参数使用说明
Sql Server 2005 默认端口修改方法
SQL Sever 2005 Express 安装失败解决办法
sql2005 根据指定字段排序编号
监视SQLServer数据库镜像[图文]
sqlserver2008 拆分字符串
字符串聚合函数(去除重复值)
SQL Server 2005 同步复制技术
SqlServer2005 链接服务器用法
SQL2008中 阻止保存要求重新创建表的更改 的解决方法
sql rollup用法 小计汇总
SQLServer 2008 Merge语句的OUTPUT功能
SQLServer 2008 新增T-SQL 简写语法
SQL Server 2005“备份集中的数据库备份与现有的数据库不同”解决方法
SQL2005 学习笔记 公用表表达式(CTE)

No. « 19 20 21 22 »

技术文章搜索

关键字

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

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