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


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Remote Data Service for ADO 2.0
  • Remote Data Service for ADO 2.1 SP2
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>
Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug kbDatabase kbDSupport KB190749
©2002 Microsoft Corporation. All rights reserved.