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



The information in this article applies to:

  • Microsoft Visual InterDev 6.0

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

  1. Create a new project.
  2. From the File menu, click New, and then click Active Server Page.
  3. Add a data connection to the Global.asa.
  4. 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.

Modification Type:MinorLast Reviewed:2/14/2005
Keywords:kbBug kbCtrl kbDatabase kbpending KB191153