Microsoft Knowledge Base Email Alertz

(245745) - 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...

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 245745 - Last Review: August 5, 2004 - Revision: 5.4

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

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 (http://download.microsoft.com/download/vb60pro/sample/12_14_2000/w98nt42kme/en-us/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  (http://kbalertz.com/Feedback.aspx?kbNumber=119591/EN-US/ ) 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:

Collapse this tableExpand this table
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/en-us/data/aa937729.aspx (http://msdn.microsoft.com/en-us/data/aa937729.aspx)
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  (http://kbalertz.com/Feedback.aspx?kbNumber=166277/EN-US/ ) HOWTO: Create a VB Component that Returns a Recordset in RDS
183294  (http://kbalertz.com/Feedback.aspx?kbNumber=183294/EN-US/ ) INFO: Techniques for Returning a Recordset via RDS
185169  (http://kbalertz.com/Feedback.aspx?kbNumber=185169/EN-US/ ) INFO: Err 0x80070005 if RDS Bus Obj not Added to ADCLAUNCH Key
191741  (http://kbalertz.com/Feedback.aspx?kbNumber=191741/EN-US/ ) INFO: RDS Registry/Security Settings For Custom Business Objects
183609  (http://kbalertz.com/Feedback.aspx?kbNumber=183609/EN-US/ ) SAMPLE: Rdsvb.exe Demonstrates How to Use RDS with Visual Basic

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
Keywords: 
kbdownload kbdatabase kbfile KB245745
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate