FIX: When You Store an ActiveX Data Objects Recordset Object Session in Internet Information Server 5.0

Article translations Article translations
Article ID: 262681 - View products that this article applies to.
This article was previously published under Q262681
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SYMPTOMS

When an ActiveX Data Objects (ADO) recordset is stored in a session variable that is in an Active Server Pages (ASP) application, you may get one of the following error messages:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Session'
-or-
Active Server Pages, ASP 0241 (0x80004005)
The CreateObject of '(null)' caused exception C0000005.
-or-
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'

CAUSE

This problem occurs because the session variables in Internet Information Server (IIS) 5.0 are stored in the Global Interface Table (GIT), and this causes an access violation with an open recordset when it is stored in a session variable.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Microsoft Data Access Components version 2.6 or later.

MORE INFORMATION

Steps to Reproduce the Behavior

To reproduce the behavior, perform the following steps:
  1. Create an ASP page on IIS 5.0 with the following code:
    <%
       Dim oConn, oRs
    	
       Set oConn = Server.CreateObject("ADODB.Connection")
       Set oRs = Server.CreateObject("ADODB.Recordset") 
    		
       oConn.Open "Provider=SQLOLEDB.1;Data Source=<ServerName>;User Id=sa;Initial Catalog=Northwind"
    
       Set oRs.ActiveConnection = oConn
       oRs.CursorLocation = 3
    	
       oRs.Open "SELECT * FROM Employees"
       Set oRs.ActiveConnection = Nothing
       
       oConn.Close
       Set oConn = Nothing
    
       'Bug occurs if ADO Recordset is stored in Session 
    variable after opening
       Set Session("session_recordset") = oRs
    
       Do While Not oRs.EOF
          Response.Write oRs("LastName") & "<BR>"
          oRs.MoveNext 
       Loop
    
       oRs.Close
       Set oRs = Nothing     	
    	
    %>
    					
  2. Browse the ASP page you created, and then refresh the ASP page. One of the error messages is displayed after you refresh the ASP page.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
249175 FIX: Storing an ADO Recordset in GIT Might Cause An Access Violation
248287 INFO: Understanding ADO Marshaling

Properties

Article ID: 262681 - Last Review: February 28, 2014 - Revision: 3.1
APPLIES TO
  • Microsoft Active Server Pages 4.0
  • Microsoft ActiveX Data Objects 2.5
  • Microsoft Internet Information Services 5.0
Keywords: 
kbnosurvey kbarchive kbado260fix kbbug kbfix kbmdac260fix KB262681

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com