SQL problem

[RTT]

I keep receiving an SQL error. Not everytime but frequently. Does anyone

know what to problem could be? This is the error i recieve:

 

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.

 

 

and this is how u connect:

conn = New SqlConnection("workstation id=" & Server & ";packet

size=4096;integrated security=SSPI;data source=" & Server & ";persist

security info=False;initial catalog=" & DB)

conn.Open()

[RTT]

I think i narrowed down the problem.

 

I wanted to build a system to report problems. So on every page i created this try-catch:

 

try...

...

...

Catch ex As Exception

Response.Redirect("error.aspx", False)

End Try

 

in the try-block i frequently used Response.redirect("page.aspx), but then he always reported an error of threadstop or something. I looked around and i read the tip of using Response.Redirect("page.aspx", False). Maybe that has something to do with it, Maybe some sources don't get disposed or something like they used to do. It's the only big change i made before the error accured.

 

Maybe some people know this, or know a better way to redirect in the middle of a method...

 

hope somebody know a solution because i'm out af ideas...

 

thxs in advance

[neodatatype]

Maybe some people know this, or know a better way to redirect in the middle of a method...

 

Mmmm... I got a similar error when I forgotten to close the connections, so after some connection was pending SQLserver didn't respond.

 

Be sure you close ALL the connections after you used it or before to change page.