How important is it to close an ADODB connection?

I ask because I am producing a page that collects form data, retrieves a record set, makes various comparisons to data within that set, then, depending on whether there are clashes (particularly dates), enter the new or edited data into the database.

If the date info clashes I intend to response.redirect back to the form page with ?string detailing error or problem. There are three IF statements checking date integrity (actually it's an IF...ELSEIF....ELSEIF...ELSE UPDATE DATA) each of which will redirect.

Is it vital that I close the connection and the record set before I redirect?

Hope this is clear. Thanks

Just put the code to close the recordset and connection in a sub and call it before any redirect or at the end of all server side code.

This will ensure that the connection and rs are closed regardless.

I'm not sure of HOW important it is in an ASP environment but not closing objects is not something I would practise in any situation, and there is no reason not to.

Rod


======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

You are wasting web server's resousces. You definely must close it. Consider the fact that each connection reserves a certain amount of memory from your server..What happens if 100 users open a connection;; I leave the answer to you..:)

Cheers
Kostas Lagos

I believe that the server session time out will close all connections. This is OK for a lightly used site, however, for a heavily used site you will certainly need to create a redirect function that closes all connections then redirects the user.