locked
File Handles Not Dropping RRS feed

  • Question

  • User624726878 posted

    After the recent Security updates in May/June 2020 our Classic ASP applications that use ADODB.Recordset no longer drops file handles?  We can see the databases being held open by w3wp.exe using Resource monitor;  this was not the behavior before the update.  Anyone know of a resolution to this?

    Wednesday, July 8, 2020 5:21 PM

All replies

  • User-848649084 posted

    Could you please share which iis version you are using, which os you are using some sample code which is causing this issue.

    you could dry to manually close the connection. 

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/northwind.mdb"
    
    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "Customers", conn
    
    rs.Close
    conn.Close
    %>
    

    Thursday, July 9, 2020 6:42 AM