I have recently upgraded my IE browser to IE8 and now my ASP app is not working. Before upgrading my code worked fine, but now, when I try to open one of the ASP pages, I get the error message above: Operation is not allowed when the object is closed.
I have an include file that opens the db connection then, within each page, I open a recordset using a query string: rsID = objConn.Execute(sSql). Listed below is the code I'm using. The error occurs on the last line of this code: set rsIds = objConn.Execute(idSql)
Could someone please help me out here? This is getting very frustrating.
In my include file:
Dim objConn, strConnect
Set objConn = Server.CreateObject("ADODB.Connection")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/RadioRoom/csrrsql.mdb")
objConn.ConnectionString = strConnect
Code in asp page:
Dim winOpen, width, height, title, fileName, sClass, id
Dim idSql, rsIds
winOpen = Request.QueryString("win")
set rsIds = Server.CreateObject("ADODB.recordset")
Select Case (UCase(winOpen))
idSql = "SELECT dbo_tblHull.HullID as ID FROM dbo_tblHull INNER JOIN dbo_tblClass ON dbo_tblHull.classID = dbo_tblClass.classID ORDER BY dbo_tblHull.HullID;"
idSql = "SELECT classID as ID FROM dbo_tblClasificaton"
title = "Subsystems"
idSql = "SELECT sybSysId as ID FROM dbo_tblSubSystem"
title = "Stowage Requirements"
idSql = "SELECT stowageID as ID FROM dbo_tblStowage"
title = "Provisioning Source Codes"
idSql = "SELECT sourceID as ID FROM dbo_tblSource"
set rsIds = objConn.Execute(idSql)