Knowledge Base

BUG: Recordset DTC Does Not Pick Up Data Connection on ASP

Article ID: 191153

Article Last Modified on 2/14/2005

Microsoft Visual InterDev 6.0 Standard Edition

This article was previously published under Q191153

SYMPTOMS

When you place the Recordset design-time control (DTC) on an Active Server Pages (ASP) page, the Recordset DTC does not pick up any data connections that are made to a project. The connections do not appear in the Connection drop-down list, but a red exclamation point appears instead.

CAUSE

When you click New on the File menu, an Active Server Page is added to the Miscellaneous folder and not the currently selected project. The Miscellaneous project is a utility folder that does not have a URL context; therefore, various features, such as design-time controls, do not function.

RESOLUTION

Right-click the project into which you want the ASP file to go, and click Active Server Page from the Add menu rather than New from the File menu.

For files that are already created, drag them from the Miscellaneous project to a Web Project in the Project Explorer.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Other DTCs or any other dynamic process also fail when they are added to a file to the Miscellaneous project.

Steps to Reproduce Behavior

Create a new project.
From the File menu, click New, and then click Active Server Page.
Add a data connection to the Global.asa.
Add a Recordset DTC.

NOTE: After you add the Recordset DTC, the Recordset DTC does not pick up any data connections that you associate with the project, rendering any DTC that relies on a Recordset non-functional.

Additional query words: page record set

Keywords: kbbug kbdatabase kbctrl kbpending KB191153