Microsoft KB Archive/248002

= PRB: Recordset DTC Causes ADODB.Properties '800a0cc1' Error =

Article ID: 248002

Article Last Modified on 4/22/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



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.



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.

