| title | Query Method (RDS) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | 20f2480f-3758-405d-a379-05a0dce74796 | |
| author | MightyPen | |
| ms.author | genemi |
Uses a valid SQL query string to return a Recordset.
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.
Set Recordset = DataFactory.Query(Connection, Query)
Recordset
An object variable that represents a Recordset object.
DataFactory
An object variable that represents an RDSServer.DataFactory object.
Connection
A String value that contains the server connection information. This is similar to the Connect property.
Query
A String that contains the SQL query.
The query should use the SQL dialect of the database server. A result status is returned if there is an error with the query that was executed. The Query method does not perform any syntax checking on the Query string.
DataFactory Object (RDSServer)
DataFactory Object, Query Method, and CreateObject Method Example (VBScript)