Connection Pooling issue

Discussion in 'ASP.NET / ASP.NET Core' started by satpk, Jul 6, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Dear All,

    I have the following issue with the three hosted accounts I have on DASP:

    I have two ASP.NET(eweb101 and eweb102) websites and one Classic ASP(web122) system.

    All three connect to an SQL Server database on SQL2k503. Now the ASP system which is the one much more in use is fine connecting to the database and I am not getting any connection errors there.

    However, the two ASP.NET websites have (for the last 3 days) been giving me the following error:

    7/6/2010 9:08:29 AM: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)


    Is this a connection pool issue? And if so, how I can clear my connection pool?

    Any help would be greatly appreciated.

    Thanks and regards,
    Satish
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page