SQL Error

microsoft.public.dotnet.languages.vb

1 Apr 2005 9:59 AM

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

1 Apr 2005 10:33 AM

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
Show quoteHide quote

"RTT" <R**@pandora.be> wrote in message
news:OZBqFGqNFHA.3336@TK2MSFTNGP09.phx.gbl...
> 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()
>
>

1 Apr 2005 11:46 AM

anonymous

Check if the SQL server debugging option is diabled. I'm
not familiar with websites, but it causes the error when
checked.

>-----Original Message-----
>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
>"RTT" <R**@pandora.be> wrote in message
>news:OZBqFGqNFHA.3336@TK2MSFTNGP09.phx.gbl...
>> 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
Show quoteHide quote

>> security info=False;initial catalog=" & DB)
>> conn.Open()
>>
>>
>
>
>.
>

1 Apr 2005 4:32 PM

smith

You might get some gains by refactoring the method so that that section
itself a function that encapsulates the resource usage and cleans up the
references before returning a bool. Then in the calling method you do
"...IF myNewMethod THEN Response.Redirect..."

Make sense? Split up the functionality.

(And could you try to post just the groups that are interested or related to
your issues?)

robert smith
kirkland, wa
www.smithvoice.com

Show quoteHide quote

"RTT" <R**@pandora.be> wrote in message
news:eMgvwYqNFHA.3984@TK2MSFTNGP12.phx.gbl...
>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
> "RTT" <R**@pandora.be> wrote in message
> news:OZBqFGqNFHA.3336@TK2MSFTNGP09.phx.gbl...
>> 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()
>>
>>
>
>