Microsoft KB Archive/248002

From BetaArchive Wiki

Article ID: 248002

Article Last Modified on 4/22/2001


  • Microsoft Visual InterDev 6.0 Standard Edition

This article was previously published under Q248002


When you view an Active Server Pages (ASP) page that has a Visual InterDev 6.0 Recordset Design-Time Control (DTC) connecting to a Microsoft Access database that uses a server-side cursor, the following error message occurs:

ADODB.Properties error '800a0cc1'
ADO could not find the object in the collection corresponding
to the name or ordinal reference requested by the application.
/PROJECTNAME/_ScriptLibrary/Recordset.ASP, line 619

NOTE: If Visual Studio Service Pack 3 is not installed, the error occurs on line 619. If the service pack is installed, the error occurs on line 462.


The Recordset.asp file is part of the script library that the Visual InterDev 6.0 Recordset Design-Time Control uses to create a recordset. If a Recordset DTC is set to use server-side cursors, the Recordset.asp page includes a line that sets the IrowsetScroll property of the ActiveX Data Objects (ADO) recordset. The IrowsetScroll property is not supported by the Access driver when you use server-side cursors.

This behavior is by design.


To resolve this issue, use client-side cursors when you use the Recordset DTC with an Access database.


Steps to Reproduce the Behavior

  1. Open a Visual InterDev project, and then add a data connection to a Microsoft Access database.
  2. Add an ASP page to the Visual InterDev project.
  3. Add a Recordset DTC to the ASP page.
  4. Right-click the Recordset DTC, click Properties, click the Advanced tab, and then click Server-side cursors.
  5. Save the ASP page, and then view it in the browser. At this point, you receive the error message described in the "Symptoms" section of this article.


For additional informations, click the article numbers below to view the articles in the Microsoft Knowledge Base:

190589 BUG: ADO Error 800a0cc1 Using SetSQLText or SetRecordsource

237276 BUG: Preserve Recordset in Session State Yields Errors or Unexpected Results

Additional query words: error 800a0cc1

Keywords: kbprb kbctrl KB248002