熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> SQL Server >> 正文

SQL Server 2000 SP4與數據鏈接池問題

2013-11-15 14:49:03  來源: SQL Server 

  今天遠程連接一台xp sp上的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: SystemInvalidOperationException: 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 : cmdCommandType = CommandTypeStoredProcedure;

  Line :

  Line : connectionOpen();

  Line : SqlCommandBuilderDeriveParameters(cmd);

  Line : connectionClose();

  但是我的連接字符串中已經設置了最大鏈接池=應該是不可能全部被占用的

  當把鏈接池設置去掉就報

  An error has occurred while establishing a connection to the server When connecting to SQL Server 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: 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: SystemDataSqlClientSqlException: An error has occurred while establishing a connection to the server When connecting to SQL Server 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: Could not open a connection to SQL Server)

  Source Error:

  Line : cmdCommandType = CommandTypeStoredProcedure;

  Line :

  Line : connectionOpen();

  Line : SqlCommandBuilderDeriveParameters(cmd);

  Line : connectionClose();

  這下子問題就明朗了典型的沒有打 Sql sp 的問題打上sp問題解決差點被誤導


From:http://tw.wingwit.com/Article/program/SQLServer/201311/22376.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.