Close connection script

P

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>
 
M

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?
 
P

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
Click to expand...
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]>
Click to expand...
wrote in message [email protected]...
 
Top