Microsoft KB Archive/216569

= PRB: Using the DE Command in a Recordset Causes an Error =

Article ID: 216569

Article Last Modified on 4/22/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q216569



SYMPTOMS
When previewing a page using a Recordset that refers to a DE Command in Microsoft Access, the following error may occur:

error '80020009'

Exception occurred

This error occurs if there is a problem with the DBQ path in the DataEnvironment.asa. This can happen if the Visual InterDev project was developed remotely from the Web server, and the Web project was later copied or deployed to the Web server.



CAUSE
When the data connection is updated or changed, those changes are not reflected in the Dataenvironment.asa.



RESOLUTION
Delete the old data connection from the project explorer and add a new data command using a system DSN on the Web server the project was deployed to.



Steps to Reproduce Behavior

 * 1) Create a project on the first Web server (server A).
 * 2) Create a system DSN for an Access.mdb on the server. Name that DSN TestDE A.
 * 3) Create a data connection using TestDE.
 * 4) Drag a table from the data view into the data environment (creating a data command).
 * 5) Create an Active Server Pages (ASP) page.
 * 6) Add a recordset DTC to that page. Have the recordset use the DE Command created above.
 * 7) Add a Grid DTC to the page. Connect it to the recordset.
 * 8) Save the ASP page.
 * 9) Copy the project to another Web server (server B).
 * 10) Copy the same Access.mdb to server B.
 * 11) Create a system DSN named TestDE2 to that same Access.mdb.
 * 12) Open the Visual InterDev project. Right-click the old data connection. Select TestDE2 and use that data connection for the recordset DTC.
 * 13) Save and Preview the ASP page.

Keywords: kbprb kbctrl KB216569

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.