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

ID: Q216569

The information in this article applies to:

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.


Additional query words: 


Keywords          : kbCtrl kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 21, 1999