Click to See Complete Forum and Search --> : How to close object?
jytioh
12-06-2004, 03:37 AM
I am facing a 'The Requested Resource is in Use' problem and one of the suggested solution is to terminate all objects. The problem is how can I do that?
I noticed that this error will come up only when I load pages with objects.
buntine
12-06-2004, 05:57 AM
Most objects have a close() function.
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open("SQL query")
rs.Close() '| Close the object
' You can also free up the space in memory by setting the variable to null (or nothing in MS-land).
Set rs = Nothing
Regards.
buntine
12-06-2004, 06:01 AM
Is this thread supposed to be part of the 'The Requested Resource is in use' thread?
I can merge the two if necessary.
Regards.