Required Client Settings

Specify the following settings to use a custom DataFactory Handler.

• Specify "Provider=MS Remote" in the Connection object Provider property or the Connection object connect string "Provider=" keyword.
  
  
• Set the 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 Connection 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:

RDS.DataControl Version:

Dim dc as New RDS.DataControl
Set dc.Handler = "MSDFMAP.Handler"
Set dc.Server = "http://YourServer"
Set dc.Connect = "Data Source=CustomerDatabase"
Set dc.SQL = "CustomerById(4)"
dc.Refresh

Recordset Version:

Dim rs as New ADODB.Recordset
rs.CursorLocation = adUseClient

Specify either the Handler property or keyword; the Provider property or keyword; and the CustomerById and CustomerDatabase identifiers. Then open the Recordset object.

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