Sometimes it’s necessary to create your own RDS server object because of some inherent limitations of the built-in RDSServer.DataFactory object. If you find it necessary to build your own version of the DataFactory, you need to keep in mind the following key items:
- You must manually add the name of your custom business object to the registry of the server. This indicates that the object is safe for initialization over http and is in addition to standard object registration.
- Input parameters to methods of the object should be passed as ByVal instead of ByRef.
- The recordset should be returned as the lightweight ADOR recordset type instead of the heavier (but more full featured) ADODB type recordset. The lighter ADOR type recordset can be passed back to the client more quickly because it is smaller than the ADODB type recordset.
- The CursorLocation property of the recordset should be set to adUseClientBatch. This allows the recordset to be disconnected from the ADO connection.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
