| 订阅 | 在线投稿
分享
 
 
 

SQL Server 2000 sp4与数据链接池问题

2008-07-22 05:34:17 编辑來源:互联网 国际版 评论
 
 
本文为【SQL Server 2000 sp4与数据链接池问题】的汉字拼音对照版显示拼音
  jintianyuanchenglianjieyitaixp sp2shangdeSQLbaocuoxinxiruxia

  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();

  danshiwodelianjiezifuchuanzhongyijingshezhilezuidalianjiechi=200yinggaishibukenengquanbubeizhanyongde

  dangbalianjiechishezhiqudiaojiubao

  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();

  zhexiaziwentijiuminglangledianxingdemeiyouda Sql2000 sp4 dewentidashangsp4wentijiejuechadianbeiwudao原文
 
 
今天远程连接一台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问题解决,差点被误导。
󰈣󰈤
 
 
>>返回首页<<
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 
 热帖排行
 
 
王朝网络微信公众号
微信扫码关注本站公众号wangchaonetcn
 
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
©2005- 王朝网络 版权所有