How To Troubleshoot "80020009 Exception Occurred" for DE Commands (253779)

SUMMARY

When you view an Active Server Pages (ASP) page in a Web browser, where the ASP page uses a Visual InterDev Recordset Design-Time Control (DTC) that references a DE Command (Data Command), you may receive the following error message:

80020009 Exception Occurred

This is a generic error message that only indicates that the connection to the database failed. This article describes how to determine the underlying reason for the connection failure.

MORE INFORMATION

To determine the underlying error that resulted in the "80020009 Exception Occurred" error, eliminate the DE Command temporarily, and specify a table as the Database Object for the Recordset because these Database Objects do not filter error messages. For example:

In the Project Explorer window, right-click your project name.
Click Add, click Active Server Page, and then click Open.
Drag a Recordset DTC from the Toolbox, and add it to the ASP page.
When you specify the database connection for your Recordset DTC, be sure to select the database connection that was used in the DE Command.
Be sure that the Database Object that the Recordset DTC uses is not a DE Command. You can use a table from your database.
Right-click your page, and click View in Browser.

NOTE: The DE Command may use connection information that is not current, which may cause the error. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

216569 Using the DE Command in a Recordset Causes an Error