Microsoft KB Archive/253779
Article ID: 253779
Article Last Modified on 8/11/2006
- Microsoft Visual InterDev 6.0 Standard Edition
This article was previously published under Q253779
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:
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.
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
Additional query words: 80020009
Keywords: kbctrl kberrmsg kbhowto KB253779