Do I have to close connections or does it makes no difference?

[zorro]

Hello there,

Am I right in thinking all connections to a database have to be closed
and objects set to nothing? I'm finishing up a web site in ASP someone
else started and most pages have this type of code:

=========
dim conn

set conn = server.createobject("adodb.connection")

conn.connectionstring ="Provider=Microsoft.Jet.OLEDB.4.0;Persist
Security Info=False;Data Source=" &
server.MapPath("../../../db/db_saad.mdb")

conn.open

set rs = conn.execute("SELECT * FROM X)

==========

But those pages have none of these:

conn.close
set conn = nothing
rs.close
set rs = nothing


Should I add this code?
And what if there's a redirect before this code?

[Rob Collyer]

Hi...

It's considered very good coding practice to close all connections as soon
as you no longer need them.

Also, set all object references to nothing as soon as you are done with them
too.

All object references however are destroyed when the page has finished
execution.

Hope this helps.
--
Rob Collyer - [url]www.webforumz.com[/url]
Web design and development forums for Free help, advice,
tips, and website critique by professional designers and developers.



"zorro" <myahact@yahoo.ca> wrote in message
news:1baa8f0d.0407181013.614f4f66@posting.google.c om...

> Hello there,
>
> Am I right in thinking all connections to a database have to be closed
> and objects set to nothing? I'm finishing up a web site in ASP someone
> else started and most pages have this type of code:
>
> =========
> dim conn
>
> set conn = server.createobject("adodb.connection")
>
> conn.connectionstring ="Provider=Microsoft.Jet.OLEDB.4.0;Persist
> Security Info=False;Data Source=" &
> server.MapPath("../../../db/db_saad.mdb")
>
> conn.open
>
> set rs = conn.execute("SELECT * FROM X)
>
> ==========
>
> But those pages have none of these:
>
> conn.close
> set conn = nothing
> rs.close
> set rs = nothing
>
>
> Should I add this code?
> And what if there's a redirect before this code?

[Jeff Cochran]

On 18 Jul 2004 11:13:04 -0700, [email]myahact@yahoo.ca[/email] (zorro) wrote:

>Hello there,
>
>Am I right in thinking all connections to a database have to be closed
>and objects set to nothing?

Have to be? No. Should be? Definite yes.

Connections close and objects are destroyed when the page closes, but
you have no control over that event happening so close connections and
destroy objects as soon as you no longer need them.

>I'm finishing up a web site in ASP someone
>else started and most pages have this type of code:
>
>=========
>dim conn
>
>set conn = server.createobject("adodb.connection")
>
>conn.connectionstring ="Provider=Microsoft.Jet.OLEDB.4.0;Persist
>Security Info=False;Data Source=" &
>server.MapPath("../../../db/db_saad.mdb")
>
>conn.open
>
>set rs = conn.execute("SELECT * FROM X)
>
>==========
>
>But those pages have none of these:
>
>conn.close
>set conn = nothing
>rs.close
>set rs = nothing
>
>
>Should I add this code?

Yes

>And what if there's a redirect before this code?

Redirect after you close. Call it as a sub, or drop through to it
with a redirect after.

Jeff