Getting Recordsets With Remote Data Services

Getting Recordsets With Remote Data Services

There are basically two ways to get recordsets with Remote Data Services (RDS). You can either use the system-provided RDSServer.DataFactory object or you can write your own full-blown custom business objects that return ADO recordsets. RDSServer.DataFactory is a general-purpose object. It takes a connection string and a command text and returns a disconnected recordset.

 rds = new ActiveXObject("RDS.DataSpace");df = rds.CreateObject("RDSServer.DataFactory", "http://expoware");rs = df.Query("DSN=Northwind", sql);

At this point, you can use the recordset to update the current page. If you need to submit changes, just use the SubmitChanges method. The recordset is sent back to the server where the stub sets up a new connection with the data source and submits the changes..

The DataFactory issues a command to the data source and returns the resulting recordset. If you need to employ more complex logic, write your own components. Your custom business objects must be registered on the server via the following registry key:


Just create a new key under ADCLaunch using the progID of your business object as its name.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular