how to send recordset object using Winsock control !
i m using Winsock control in my client/server application using vb6. from the server machine i m trying to send the recordset object to the client machine. on the client machine i pass this object to the data source property of the report object. this thing is not happening. can any one plz help me. how i can send the recordset object from the server machine to the client.
thanx
ROAMER :wave:
Re: how to send recordset object using Winsock control !
Are these machines seperated by the internet? you may want to transfer them as XML or open up firewall ports to allow them to communicate
Re: how to send recordset object using Winsock control !
I just read the data from the recordset and write it in a PropertyBag, then I send the property bag to the client. Then I just read the data from the PropertyBag at the client side.
1 Attachment(s)
Re: how to send recordset object using Winsock control !
Somewhat outdated this thread is, but I still develop some things in VB6...
Re: how to send recordset object using Winsock control !
The standard way to do this is to Save the Recordset to an ADO Stream object in either native ADTG or ADO XML format. You can then Read the contents of the Stream into a Byte array or ReadText it into a String. Then send this.
Reverse the process at the other end.