Step 3: Server Obtains a Recordset (RDS Tutorial)

See Also   

You are Here...

Discussion

The server program uses the connect string and command text to query the data source for the desired rows. ADO is typically used to retrieve this Recordset, although other Microsoft data access interfaces, such as OLE DB, could be used. See the ADO Tutorial for a detailed explanation of how the query is performed.

A custom server program might look like this:

Public Function ServerProgram(conn as String, qry as String) as Object
Dim rs as New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open cn, qry, adOpenUnspecified, adLockUnspecified, _
  adCmdUnspecified
Set ServerProgram = rs
End Function

Next   Step 4