Thursday, March 22, 2012

Connection Pool gone berzerk.

Anyone suddenly having problems with connections not being reused after
applying the latest updates from MS? Specifically...
Successful Wednesday, July 14, 2004 Security Update for Windows 2000
(KB839645) Automatic update
Successful Wednesday, July 14, 2004 Security Update for Windows 2000
(KB841872) Automatic update
Successful Wednesday, July 14, 2004 Security Update for Windows 2000
(KB841873) Automatic update
Successful Wednesday, July 14, 2004 Security Update for Windows 2000
(KB840315) Automatic update
Successful Wednesday, July 14, 2004 Security Update for Windows 2000
(KB842526) Automatic update
Successful Wednesday, July 14, 2004 Cumulative Security Update for
Outlook Express 6 SP1 (KB823353) Automatic update
I'm using the Data Application Block and passing the SAME connection string
with only one exception: I manually connect and pass the connection object
rather than the connection string in a couple of routines...and, yes, the
connections are closed before exiting.
The strange thing is...all this worked great until the security updates
above were applied. No other changes.
Now, I run about 5-6 queries and, boom, I'm over the Max Limit default of
100.
Anyone else run into this?
Davebtw, it's "berserk" not "berzerk".
"Dave Diehl" <d.diehl@.worldnet.att.net> wrote in message
news:uQoEzMcaEHA.2488@.tk2msftngp13.phx.gbl...
> Anyone suddenly having problems with connections not being reused after
> applying the latest updates from MS? Specifically...
> Successful Wednesday, July 14, 2004 Security Update for Windows 2000
> (KB839645) Automatic update
> Successful Wednesday, July 14, 2004 Security Update for Windows 2000
> (KB841872) Automatic update
> Successful Wednesday, July 14, 2004 Security Update for Windows 2000
> (KB841873) Automatic update
> Successful Wednesday, July 14, 2004 Security Update for Windows 2000
> (KB840315) Automatic update
> Successful Wednesday, July 14, 2004 Security Update for Windows 2000
> (KB842526) Automatic update
> Successful Wednesday, July 14, 2004 Cumulative Security Update for
> Outlook Express 6 SP1 (KB823353) Automatic update
>
> I'm using the Data Application Block and passing the SAME connection
string
> with only one exception: I manually connect and pass the connection object
> rather than the connection string in a couple of routines...and, yes, the
> connections are closed before exiting.
> The strange thing is...all this worked great until the security updates
> above were applied. No other changes.
> Now, I run about 5-6 queries and, boom, I'm over the Max Limit default of
> 100.
> Anyone else run into this?
> Dave
>

No comments:

Post a Comment