Microsoft KB Archive/190749

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

Article ID: 190749

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Remote Data Service for ADO 2.0
 * Microsoft Remote Data Services 2.1

-



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.



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.      

 \ \;DefaultDir=\\\ ;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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.