response.redirect and recordset/connection object?

[nick]

I have the following code. Should I close and release the database objects
before run response.redirect("some url")? or will the response.redirect
automatically close the database object/connection like the end of asp
script? I am using IIS 3.

.......
var cmd = Server.CreateObject("ADODB.Command")
var rs = Server.CreateObject("ADODB.Recordset")
cmd.ActiveConnection = conn
cmd.CommandText = strCmd
cmd.CommandType = adCmdStoredProc
rs.Open(cmd)

.......

response.redirect("some url")

[CJM]

I set all my objects to Nothing before I redirect.

I'm not certain about this, but I dont see how redirecting is any different
to any other situation, and therefore we must clean up our mess. Besides,
it's not that much of a bind anyway...

Chris

[Bullschmidt]

I generally close recordset objects as soon as I'm done using them. And
I generally close the connection at the end of the page and just before
any redirects even though this MAY POSSIBLY be done automatically.

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
[url]http://www.Bullschmidt.com[/url]
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[IPT]

This is just a guess from me.

If webserver has HTTP-Connection Kept Alive set ON, connection may not be
closed when redirect.

> I have the following code. Should I close and release the database objects
> before run response.redirect("some url")? or will the response.redirect
> automatically close the database object/connection like the end of asp
> script? I am using IIS 3.
>
> ......
> var cmd = Server.CreateObject("ADODB.Command")
> var rs = Server.CreateObject("ADODB.Recordset")
> cmd.ActiveConnection = conn
> cmd.CommandText = strCmd
> cmd.CommandType = adCmdStoredProc
> rs.Open(cmd)
>
> ......
>
> response.redirect("some url")