Knowledge Base

BUG: Data Does Not Display When You Preview an RDS-Based Page

Article ID: 190749

Article Last Modified on 10/15/2002

APPLIES TO

This article was previously published under Q190749

SYMPTOMS

When a user previews a page that uses Remote Data Service (RDS) to retrieve data from a Microsoft Access database that is located on a third computer by using a UNC path, the user will not see any data in the browser.

CAUSE

The problem occurs because of a limitation of Windows NT user impersonation. In Windows NT 4.0, the authentication information cannot be passed from one computer to another for verification. Because RDS does not return any error information, no error or data is seen in the browser.

RESOLUTION

To work around this problem, the user can use a drive letter to set up a connection to an Access database on local computer.

STATUS

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

MORE INFORMATION

Steps to Reproduce Behavior

Here is an example of an .htm page that reproduces this behavior. Add this page to a Visual InterDev Web project, and preview it. 
   <HTML>
   <HEAD>
   <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
   <META HTTP-EQUIV="Content-Type" content="text/html">
   </HEAD>
   <BODY>

   <OBJECT classid=clsid:BD96C556-65A3-11D0-983A-00C04FC29E33 height=1
    style="LEFT: 0px; TOP: 0px" width=1 id="RDS1">
   <PARAM NAME="Server" VALUE="<web server name">
   <PARAM NAME="Connect" VALUE="DRIVER={Microsoft Access Driver
    (*.mdb)};User Id=admin;DBQ=\\<machine-name>\<share>\<mdb-
    file>;DefaultDir=\\<machine-name>\<share>;DriverId=25;FIL=MS
    Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;
    PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes">
   <PARAM NAME="SQL" VALUE="Select id from TBL">
   </OBJECT>

   <input type="text" id=text2 name=text2 datasrc=#RDS1 datafld="id">
   </BODY>
   </HTML>

Keywords: kbbug kbdatabase kbpending KB190749


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.