PRB: Recordset DTC Causes ADODB.Properties '800a0cc1' Error (248002)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
This article was previously published under Q248002

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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

MORE INFORMATION

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.

REFERENCES

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

Modification Type:MajorLast Reviewed:4/22/2001
Keywords:kbCtrl kbprb KB248002
©2002 Microsoft Corporation. All rights reserved.