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:
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
- Open a Visual InterDev project, and then add a data connection to a Microsoft Access database.
- Add an ASP page to the Visual InterDev project.
- Add a Recordset DTC to the ASP page.
- Right-click the Recordset DTC, click Properties, click the Advanced tab, and then click Server-side cursors.
- 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
Additional query words: error 800a0cc1
Keywords: kbprb kbctrl KB248002