Detect Record State and Database State. Close recordset and database

By: Lee A. Shurie
Subject:	Recordsets and database connections
Language:	ASP
Rating:	Rated 46 times. Rate or review this item: 1 2 3 4 5  Read Reviews
Information This code snippet illustrates how to detect an open recordset and close it. Same for an open database connection. If you do not first detect the state of the recordset or the database and you attempt to close it, you will get an error if it is not open. This code eliminates the error by first detecting the state of the recordset or the database connection.
Code '<!-- Cleanup --> '<!-- If recordset is open as rs, then close it --> If rs.state <> adStateClosed Then rC.Close Set s = Nothing End If '<!-- If database connection is open as c, then close it --> If TypeName(c) = "Connection" Then If c.state <> adStateClosed Then c.Close Set c = Nothing End If '<!-- // End Cleanup -->
Keywords:asp detect open recordset, detect open database connection, close recordset, close database connection