----- Original Message -----
From: Lyris ListManager <lyris@p...>
To: <farhan-zia@c...>
Sent: Wednesday, March 27, 2002 11:50 PM
Subject: Re: Pooling problem in .net final release


> Sorry, your message was not sent out to 'aspx_beginners'
> because the first line of the message is identical
> to a message you sent to vb_dotnet recently.
>
> If you believe you are receiving this message in error,
> resend your message with a different first line.
>
> The matching message and your message are reproduced below.
>
> ---
>
> The matching message, from the list archives: (MESSAGE-ID:159877)
>
> Return-Path: <farhan-zia@c...>
> Return-Path: <farhan-zia@c...>
> Received: from newsmtp.cyber.net.pk ([202.163.96.5]) by mail.p2p.wrox.com
with SMTP (Lyris ListManager LINUX version 5.0c); Wed, 27 Mar 2002 19:47:56
+0100
> Received: from smtp.cyber.net.pk ([202.163.96.5]) by newsmtp.cyber.net.pk
>           (Post.Office MTA v3.5.3 release 223 ID#
0-61202U24000L20000S0V35)
>           with SMTP id pk; Thu, 28 Mar 2002 00:49:59 +0500
> Received: from Farhan ( [202.163.106.140]) by smtp.cyber.net.pk with SMTP
(MailShield v2.04 - SOLARIS/SPARC Jul 18 2001 17:16:48); Thu, 28 Mar 2002
00:49:58 +0500
> Message-ID: <017e01c1d5c8$24bb1360$8c6aa3ca@F...>
> From: "Farhan Zia" <farhan-zia@c...>
> To: <vb_dotnet@p...>,
> <asp_dotnet_app_design@p...>,
> <aspx@p...>,
> <aspx_beginners@p...>,
> <aspx_professional@p...>
> Subject: Pooling problem in .net final release
> Date: Thu, 28 Mar 2002 00:46:44 +0500
> Organization: Personal
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Mailer: Microsoft Outlook Express 5.00.2615.200
> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
>
>  i have converted my system from .net betaII to final release. I need
some
> help regarding it. Actually I am working on a 3 tier
> architecture... SQL at back end, VB.Net as middle layer and asp.net at
from
> end. After migrating to final release, as I tried to access my  site... it
> throws an exception saying "Server timeout before getting a  connection
from
> pool. This could happen because all connection objects in the pool are in
> use and the maximum size of pool is reached."
> I tested my COM(middle layer) through a .net windows application and it
> works perfectly well. But when accesed through ASP.Net... I get this
error.
> Even I cannot login to my site.
>
> Please help. Thanks
> Farhan Zia
>
>
>
>
> ---
>
> Your message: (INMAIL-ID:143987)
>
> Return-Path: <farhan-zia@c...>
> Received: from newsmtp.cyber.net.pk ([202.163.96.5]) by mail.p2p.wrox.com
with SMTP (Lyris ListManager LINUX version 5.0c); Wed, 27 Mar 2002 19:50:34
+0100
> Received: from smtp.cyber.net.pk ([202.163.96.5]) by newsmtp.cyber.net.pk
>           (Post.Office MTA v3.5.3 release 223 ID#
0-61202U24000L20000S0V35)
>           with SMTP id pk for <aspx_beginners@p...>;
>           Thu, 28 Mar 2002 00:52:40 +0500
> Return-Path: <farhan-zia@c...>
> Received: from Farhan ( [202.163.106.140]) by smtp.cyber.net.pk with SMTP
(MailShield v2.04 - SOLARIS/SPARC Jul 18 2001 17:16:48); Thu, 28 Mar 2002
00:52:39 +0500
> Message-ID: <019101c1d5c8$848579c0$8c6aa3ca@F...>
> From: "Farhan Zia" <farhan-zia@c...>
> To: <aspx_beginners@p...>
> Subject: Pooling problem in .net final release
> Date: Thu, 28 Mar 2002 00:49:28 +0500
> Organization: Personal
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Mailer: Microsoft Outlook Express 5.00.2615.200
> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
>
> i have converted my system from .net betaII to final release. I need  some
> help regarding it. Actually I am working on a 3 tier
> architecture... SQL at back end, VB.Net as middle layer and asp.net at
from
> end. After migrating to final release, as I tried to access my  site... it
> throws an exception saying "Server timeout before getting a  connection
from
> pool. This could happen because all connection objects in the pool are in
> use and the maximum size of pool is reached."
> I tested my COM(middle layer) through a .net windows application and it
> works perfectly well. But when accesed through ASP.Net... I get this
error.
> Even I cannot login to my site.
>
> Please help. Thanks
> Farhan Zia
>
>
>
>

hello.....i have converted my system from .net betaII to final release. I
need  some help regarding it. Actually I am working on a 3 tier
architecture... SQL at back end, VB.Net as middle layer and asp.net at  from
end. After migrating to final release, as I tried to access my  site... it
throws an exception saying "Server timeout before getting a  connection from
pool. This could happen because all connection objects in the pool are in
use and the maximum size of pool is reached." I tested my COM(middle layer)
through a .net windows application and it works perfectly well. But when
accesed through ASP.Net... I get this error. Even I cannot login to my site.

Please help. Thanks
Farhan Zia

I also had this pooling problem, I think it the problem occurs if you do 
not close a (SQL)DataReader properly: myDataReader.Close(), before closing 
the connection again!

I went through all my code and closed all my DataReaders properly, now I 
do not notice this problem anymore...


> hello.....i have converted my system from .net betaII to final release. I
need  some help regarding it. Actually I am working on a 3 tier
architecture... SQL at back end, VB.Net as middle layer and asp.net at  
from
end. After migrating to final release, as I tried to access my  site... it
throws an exception saying "Server timeout before getting a  connection 
from
pool. This could happen because all connection objects in the pool are in
use and the maximum size of pool is reached." I tested my COM(middle layer)
through a .net windows application and it works perfectly well. But when
accesed through ASP.Net... I get this error. Even I cannot login to my 
site.

Please help. Thanks
Farhan Zia