After closing the connection, it gets added to connection pool. If you
do not want the closed connection to be pooled, then dispose the
connection immediately after you close it.
sqlConn.Dispose();
would do it.
Raj.
-----Original Message-----
From: Mechzen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 4:01 AM
To: ASP.NET
Subject: [AspNetAnyQuestionIsOk] database connection .. pls help
Hi all,
When V connect 2 database we use the connectionstring
and do it also V always create the connection/command object and then
work with it and free it...immediately...rt?? 'cos ours(.NET) is
disconnectecd architecture....
But, the problem is since V make soo much dynamic connection
and free it..they R not getting actually freed...i.e THey R maintained
in a POOL which is getting accumulated...That is a problem/....
Can U tell how is database connection done there???? It will be
very helpful...waiting...
regards brijesh
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129sgv5p8/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1089792064/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=776276247>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
cribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
