| title | Required Client Settings | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 11/09/2018 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | e776b4e3-fcc4-4bfb-a7e8-5ffae1d83833 | |
| author | MightyPen | |
| ms.author | genemi |
Important
Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.
Specify the following settings to use a custom DataFactory handler.
-
Specify "Provider=MS Remote" in the Connection Object (ADO) object Provider Property (ADO) property or the Connection object connection string "Provider=" keyword.
-
Set the CursorLocation Property (ADO) property to adUseClient.
-
Specify the name of the handler to use in the DataControl Object (RDS) object's Handler property, or the Recordset Object (ADO) object's connection 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 that the following sections in MSDFMAP.INI and the data source name, AdvWorks, have been previously defined:
[connect CustomerDataBase]
Access=ReadWrite
Connect="DSN=AdvWorks"
[sql CustomerById]
SQL="SELECT * FROM Customers WHERE CustomerID = ?" The following code snippets are written in Visual Basic:
Dim dc as New RDS.DataControl
Set dc.Handler = "MSDFMAP.Handler"
Set dc.Server = "https://yourServer"
Set dc.Connect = "Data Source=CustomerDatabase"
Set dc.SQL = "CustomerById(4)"
dc.Refresh Dim rs as New ADODB.Recordset
rs.CursorLocation = adUseClient Specify either the Handler Property (RDS) property or keyword; the Provider Property (ADO) 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=https://yourServer" Customization File Connect Section
Customization File SQL Section
Customization File UserList Section
DataFactory Customization
Required Client Settings
Understanding the Customization File
Writing Your Own Customized Handler