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

ID: Q190749

The information in this article applies to:

SYMPTOMS

When an user previews a page, which uses RDS to retrieve data from an access database located on a third machine using a UNC path, in the browser, they will not see any data in the browser.


CAUSE

The problem is caused by a limitation of Windows NT user impersonation. Currently in Windows NT 4.0, the authentication information cannot be passed from one machine to another for verification. Since, RDS does not return many error information, no error or data is seen in the browser.


RESOLUTION

The user can work around this by using a drive letter for setting up a connection to an access database on local machine.


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

Steps to Reproduce Behavior

Here is an example of an .htm page, which would reproduce the above 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>

Additional query words: 


Keywords          : kbADO kbVisID600bug kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 20, 1999