SAMPLE: RDS_Comp.exe Demonstrates How to Use the RDS.Dataspace Object from Client Script (245745)


The information in this article applies to:

  • Microsoft Data Access Components 1.5
  • Microsoft Data Access Components 2.0
  • Microsoft Data Access Components 2.1
  • Microsoft Data Access Components 2.1 (GA)
  • Microsoft Data Access Components 2.1 SP1
  • Microsoft Data Access Components 2.1 SP2
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
This article was previously published under Q245745

SUMMARY

Remote Data Services (RDS) is a technology that allows client-side Web applications to have database connectivity. With RDS, the user can make remote calls to an ActiveX DLL that is hosted on a Web service and can use the methods of that component to retrieve and update ADO recordsets. The remote access to the DLL is made through the RDS.Dataspace object.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

RDS_Comp.exe

Release Date: Dec-15-2000

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The RDS_Comp.exe file contains the following files:

RDS_Comp.VBP1 KB
Class1.CLS3 KB
RDS_Comp.DLL24 KB
TestPage.HTM5 KB
DblClickMe.REG1 KB
ReadMe.TXT1 KB
MSDatGrd.LPK1 KB


RDS_Comp.exe is a sample in a self-extracting executable. This file contains files and sources that demonstrate how to use client-side script to retrieve an ADO Recordset from a remote Visual Basic component through the RDS.Dataspace object. The codes then shows how to bind this recordset to a client-side ActiveX control (specifically the Microsoft DataGrid control) and then submit the changes back through the server-side Visual Basic component to update the underlying data source.

Microsoft assumes that the user is familiar with Visual Basic, either VBScript or JScript, and also has some database development experience. The server-side code is written in Visual Basic, and the client-side code is script-embedded in the HTML page. Client code is demonstrated in both VBScript and JScript. The ADO recordset is bound to the Microsoft DataGrid control. However, this code may be modified to use other data-aware controls, as long as the controls support binding to an ADO recordset.

Microsoft also assumes that the user is running Microsoft Internet Information Server (IIS) 4.0 and has installed the Microsoft Data Access Components (MDAC) version 2.1 or later on the IIS server. To obtain the latest version of MDAC, see the following Microsoft Web site:

http://msdn.microsoft.com/dataaccess

NOTE: MDAC 2.5 is installed with Microsoft Windows 2000.

The ReadMe.txt file that is included in the self-extracting download has more detailed instructions on how to set up and run this sample.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

166277 HOWTO: Create a VB Component that Returns a Recordset in RDS

183294 INFO: Techniques for Returning a Recordset via RDS

185169 INFO: Err 0x80070005 if RDS Bus Obj not Added to ADCLAUNCH Key

191741 INFO: RDS Registry/Security Settings For Custom Business Objects

183609 SAMPLE: Rdsvb.exe Demonstrates How to Use RDS with Visual Basic

Modification Type:MinorLast Reviewed:8/5/2004
Keywords:kbdownload kbDatabase kbfile KB245745 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.