ADO Objects have a "STATE" property. The "Connection" object (as well as the "RecordSet" object) may need to be closed [also].


>Hello,
>
>I have a website with mixed ADO and VFP control of VFP tables. I am getting an Access Denied error during a sequence of events. I believe it's because, during part of a process which involves numerous ASP pages and using ADO Recordsets, an ADO connection is not getting closed. I have placed
>*........
>Recordset1.close()
>Set Recordset1 = nothing
>*........
>at the bottom of every page that uses the ADO connections. But when I get to a page that uses a VFP DLL Proc to Open a table EXCLUSIVEly, I get the Access Denied -1705 error message returned from the DLL.
>
>If a page with a Form Submit does a Response.Redirect to a second page, how then is the ADO connection of the first page being terminated? I've tried placing the Recordset1.close commands just before the Redirect, but I get an Object-related error(the ojbect hasn't been created yet, I presume).
>
>The DLL code has CLOSE DATABASE ALL and CLOSE TABLE ALL at the beginning of the Proc being called. It appears that SOMETHING, SOMEWHERE is being left OPEN on the Server.
>Does the Recordset1.Close() code at the bottom of the ASP page get executed even if a Redirect is processed at the Top of the page?
>
>Any feedback about this will be appreciated.
>
>Thank you
>
>David