ASP.NET

ASP.NET RSS

Time Expired, pool is full

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Feb 2008

Posts: 9

Reputation: themailsian is an unknown quantity at this point

Solved Threads: 0

themailsian themailsian is offline

Offline

Newbie Poster

Time Expired, pool is full

May 27th, 2008

Hello dears,
I m facing below mentioned Error in my application.
where as all my database connections are closed.

my code is as under:
i have made a function that is being used with each type of query in my application.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Public Function exeQuery(ByVal query As String) As String
        Dim msg As String
        Try
            connect()
            fComm = New SqlCommand(query, fConn)
            fComm.ExecuteNonQuery()
            fConn.Close()
            fConn.Dispose()
            Return "1"
        Catch ex As Exception
            fConn.Close()
            msg = ex.Message.ToString()
            Return msg
        Finally 
            fConn.Close()
        End Try
    End Function
Public Function exeQuery(ByVal query As String) As String
        Dim msg As String
        Try
            connect()
            fComm = New SqlCommand(query, fConn)
            fComm.ExecuteNonQuery()
            fConn.Close()
            fConn.Dispose()
            Return "1"
        Catch ex As Exception
            fConn.Close()
            msg = ex.Message.ToString()
            Return msg
        Finally 
            fConn.Close()
        End Try
    End Function

'Execute Insert, Update and Delete Queries
but when 3 or 4 person use this at the same time it gives the error.
Please suggest me most convenient way at earliest.

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.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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.
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.

Best Regards,

Naveed

Last edited by peter_budo; May 31st, 2008 at 8:11 am. Reason: Keep It Organized - please use [code] tags

Needo

•

Join Date: May 2008

Posts: 43

Reputation: sebastian3 is an unknown quantity at this point

Solved Threads: 1

sebastian3 sebastian3 is offline

Offline

Light Poster

Re: Time Expired, pool is full

May 28th, 2008

Cant comment without viewing the Connect() function.

Check whether the function is returning where u have given the Return 1 statement without calling the finally block.
You can check whether any Datareaders remains unclosed.

•

Join Date: Dec 2007

Posts: 291

Reputation: ericstenson is an unknown quantity at this point

Solved Threads: 29

ericstenson ericstenson is offline

Offline

Posting Whiz in Training

Re: Time Expired, pool is full

May 29th, 2008

In your connection string to the database add Pooling=False;

I caution you, however, there is something "seriously concerning" if you are exceeding 100 connections to your db at the same time. make sure you are closing out your connections! do you have background threads using the db????

--
"Dummy."