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

ID: Q190749

The information in this article applies to:

Microsoft Visual InterDev, version 6.0
Remote Data Service for ADO versions 2.0, 2.1 SP2

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.

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 kbGrpMDAC kbRDS210SP2
Version : WINDOWS:2.0,2.1 SP2,6.0
Platform : WINDOWS
Issue type : kbbug