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.