PRB: Using the DE Command in a Recordset Causes an Error (216569)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
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.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:4/22/2001
Keywords:kbCtrl kbprb KB216569
©2002 Microsoft Corporation. All rights reserved.