Share via

Sending a Data Recordset in a Message (COM)

  • Article

A version of this page is also available for

Windows Embedded CE 6.0 R3

4/8/2010

Data recordsets can be sent and retrieved using a combination of Message Queuing and Microsoft Remote Data Service (RDS).

Note

RDS is used to transport ActiveX Data Object recordsets from a server to a client computer. The resulting recordset is cached on the client computer and disconnected from the server.

To send a data recordset in a message

  1. Make sure RDS and Microsoft SQL Server are installed on your computer.

  2. Make sure SQL Server services has been stated.

  3. Add references to the appropriate object libraries.

  4. Create a destination queue and open it with send access.

  5. Create the recordset.

  6. Create and send a message and then set the body of the message to the ActiveX Data Object recordset.

  7. Open the queue with receive access and retrieve the message.

  8. Create a new recordset using the body of the retrieved message.

See Also

Concepts

MSMQ COM Support
Using the COM Components
MSMQ Security

Other Resources

Message Queuing