Microsoft KB Archive/245745

From BetaArchive Wiki
Knowledge Base


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

Article ID: 245745

Article Last Modified on 8/5/2004



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 Service Pack 2
  • Microsoft Data Access Components 2.1 Service Pack 1
  • Microsoft Data Access Components 2.1 Service Pack 2
  • 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:

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.VBP 1 KB
Class1.CLS 3 KB
RDS_Comp.DLL 24 KB
TestPage.HTM 5 KB
DblClickMe.REG 1 KB
ReadMe.TXT 1 KB
MSDatGrd.LPK 1 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:

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



Additional query words: RDS_Comp

Keywords: kbdownload kbdatabase kbfile KB245745