Required Client Settings

Specify the following settings to use a custom DataFactory Handler.

• Specify "Provider=MS Remote" in the Connect object Provider property or the Connect object connect string "Provider=" keyword.
  
  
• Set the RDS.DataControl CursorLocation property to adUseClient.
  
  
• Specify the name of the Handler to use in the RDS.DataControl Handler property, or the Recordset object connect string "Handler=" keyword. (You cannot set the Handler in the Connect object connect string.)
  RDS provides a default Handler on the server named MSDFMAP.Handler. (The default customization file is named MSDFMAP.INI.)

Example

Assume the following sections in MSDFMAP.INI, and that the data source name, AdvWorks, has been previously defined:

[connect CustomerDataBase]
Access=ReadWrite
Connect="DSN=AdvWorks"

[sql CustomerById]
SQL="SELECT * FROM Customers WHERE CustomerID = ?"

In Visual Basic:

Dim rdsConnect as New ADOR.Connect
Dim rs as New ADOR.Recordset
Dim rdsControl as New RDS.DataControl

rdsConnect.Provider="MS Remote"
rdsControl.CursorLocation = adUseClient

Specify either the Handler property:

rdsControl.Handler = "MSDFMAP.Handler"

Or the Handler keyword. Also specify the CustomerById and CustomerDatabase identifiers. You could alternately specify the Provider keyword instead of the Provider property:

rs.Open "CustomerById(4)", "Handler=MSDFMAP.Handler; Provider=MS Remote;
         Data Source=CustomerDatabase;Remote Server=http://YourSite"