Andy and Kim Mills <[EMAIL PROTECTED]> wrote:Hello Guys:
Should I close a database connection after each page? I know you should close and destroy any Recordsets, objects etc after you are finished with them: but I thought I remembered reading one time on Microsoft that you should not close the database connection, as this will allow for connection pooling (we use SQL Server 2000). However: old age has slowly crept up upon me, and I am not sure if that was true or not. Thanks for any help Andy --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. hi, Closing the Database connection is a good practice ... anyway if u dont close the connection it will automatically close when it loses the scope. connection pooling is major advantage in oleDB. we can have limited no of connection at the time.so there can be N number of users can access the DB... if u close the Connection it will be sent to pool...if any user needed the connection it can take it from the pool instead of creating new connection(provided if u have same User Id). regards, D.newton Yahoo! India Matrimony: Find your partner online. [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/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> 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/
