Close connection script

[Paul Milner]

Hi
Thomas was good enough to pass on this code to close a
record set after it has downloaded to help stop a
database from exeeding it's connection limit.
He said that it will need to be modified to to handle FP
naming convention. How? and How can I test to see if it
is working
Best wishes
Paul M

Close Connection:
<%
Connection.Close
Set Connection = Nothing
%>

Close Recordset:
<%
fp_rs.Close
Set fp_rs = Nothing
%>

I normally place these after the closing </html>

 

[MD Websunlimited]

Hi Paul,

If you're using the FP DRW or DIW it will automatically be closed by the code inserted by FP.

What are you attempting to accomplish here?

 

[Paul M]

Thanks Mike
You answered my question. Because I am connected to An
Access database with only 255 concurent connections aloud
and not a sql database with its many, I didn't want it
to be bogged with unclosed connections from previous
searches
Best wishes
Paul M

-----Original Message-----
Hi Paul,

If you're using the FP DRW or DIW it will automatically

be closed by the code inserted by FP.

What are you attempting to accomplish here?


--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

"Paul Milner" <[email protected]>

wrote in message [email protected]...