Classic ASP Discussion - Implicit Connection with Recordset

Print Page | Close Window

Implicit Connection with Recordset

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=12023
Printed Date: 30 March 2026 at 11:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Implicit Connection with Recordset

Posted By: Misty
Subject: Implicit Connection with Recordset
Date Posted: 02 October 2004 at 2:54pm

I am concerned because I read the following article at http://support.microsoft.com/default.aspx?scid=kb;en-us;191572&Product=ado - http://support.microsoft.com/default.aspx?scid=kb;en-us;1915 72&Product=ado . I really need to be able to use recordset. I decided to set both the ConnectionString to nothing and recordset to nothing at the end of the web page. Will this solve thr problem with Implicit Connection?

Replies:

Posted By: longcall911
Date Posted: 03 October 2004 at 2:39pm

I always use the explicite connection type, setting the connection and opening it. I find the code easier to follow later.

When done with the db, I close the connection and set the object to nothing. This approach definitely returns the connection to the pool as stated in the MS article you quote.

/*tom*/

-------------
make your meetings interactive with an http://www.comtec-ars.com" rel="nofollow - Audience Response System