DataFactory Customization

Remote Data Service (RDS) provides a way to easily perform data access in a three-tier client/server system. A client data control specifies connection and command string parameters to perform a query on a remote data source, or connection string and Recordset object parameters to perform an update.

The parameters are passed to a server program, which performs the data-access operation on the remote data source. RDS provides a default server program called the RDSServer.DataFactory object. The RDSServer.DataFactory object returns any Recordset object produced by a query to the client.

However, the RDSServer.DataFactory is limited to performing queries and updates. It cannot perform any validation or processing on the connection or command strings.

With ADO, you can specify that the DataFactory work in conjunction with another type of server program called a handler. The handler can modify client connection and command strings before they are used to access the data source. In addition, the handler can enforce access rights, which govern the ability of the client to read and write data to the data source.

The parameters the handler uses to modify client parameters and access rights are specified in sections of a customization file.

See the following topics for more information about customizing the DataFactory object:

• Understanding the Customization File
• Customization File Connect Section
• Customization File SQL Section
• Customization File UserList Section
• Customization File Logs Section
• Required Client Settings
• Writing Your Own Customized Handler