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

ID: Q191153


The information in this article applies to:


SYMPTOMS

The Recordset Design-time control (DTC), when placed on an Active Server Pages (ASP) page, will not pick up any data connection made to a project. The connections will not show up in the connection drop-down list and a red exclamation point will show up instead.


CAUSE

When choosing the File New, an Active Server Page gets added to the Miscellaneous folder and not the current selected project. The Miscellaneous project is a utility folder that does not have a URL context. Therefore, various features, such as design-time controls, will not function.


RESOLUTION

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

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


STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.


MORE INFORMATION

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

Steps to Reproduce Behavior

  1. Create a new project.


  2. From the File menu, select New and Active Server Page.


  3. Add a data connection to the Global.asa.


  4. Add a Recordset DTC.


Note that once the Recordset DTC is added, it does not pick up any data connections you associate with the project, rendering any DTC that relies on a Recordset non-functional.

Additional query words: page record set


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

Last Reviewed: May 24, 1999