Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADO & WinSock
- Thread starter TRYP
- Start date
- Thread starter
- #2
TRYP - Don't get frustrated so easily -- sometimes it takes a while before someone notices your message.
But, to answer your question, you can't (obviously) pass the recordset over a winsock connection because a recordset is an object. You must first serialize the recordset into a string. Best way to do this is convert it to XML using ado's save method with the adPersistXML flag on it.
MyRS.Save "OutputFile.XML, adPersistXML
You then send it over your winsock connection, saving it as a temp file on the other end. To get it back into a recordset, open the file like this:
rs.Open "c:\winnt\temp\MyFile.XML",,,,adCmdFile
Hope this helps.
Chip H.
But, to answer your question, you can't (obviously) pass the recordset over a winsock connection because a recordset is an object. You must first serialize the recordset into a string. Best way to do this is convert it to XML using ado's save method with the adPersistXML flag on it.
MyRS.Save "OutputFile.XML, adPersistXML
You then send it over your winsock connection, saving it as a temp file on the other end. To get it back into a recordset, open the file like this:
rs.Open "c:\winnt\temp\MyFile.XML",,,,adCmdFile
Hope this helps.
Chip H.
- Thread starter
- #4
- Thread starter
- #6
- Status
