Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 13th, 2006, 08:19 AM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

To answer your question, if memory serves me correctly, when you call response.redirect execution of the current page stops and execution of the new page begins.

Personally I will not call a response.redirect while I have a database connection open, if my condition is based on a piece of data and that piece of data is found I will break out of my loop (or method) and go to my conditional statement and redirect AFTER i have closed my connections.

As an aside, even if after you called response.redirect and the ASP Process was supposed to clean up the connection for you, you should not rely on the process to clean up your connections for you because can you be 100% certain that the connection got closed? By manually closing the connection yourself you will know that the connection is closed, leaving it up to the ASP process to close the connection is bad practice and one should not get in the habit of relying on the process to do garbage collection.

"The one language all programmers understand is profanity."

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using DAO and ADO within ADODB.connection faridrd Access VBA 0 January 8th, 2008 10:43 PM
Help.Can i use ADODB.Connection with DetailsView? aekta ASP.NET 2.0 Professional 5 March 11th, 2007 06:08 AM
ADODB.Connection (0x800A0E7A) sumanst Classic ASP Databases 1 August 5th, 2005 02:56 PM
ADODB connection for Recordset dpatole Beginning VB 6 1 October 14th, 2003 04:24 PM
ADODB Connection String misterqj Access 2 September 30th, 2003 06:30 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.