I´m programming attaching a SQLserver 7.0 database, using ADO.

Can you tell me a way to sort an ADO recordset with adLocation property = adUseServer (it´s necessary for me, cannot locate in Client, i need to see changes) with the sort method?

I think i cannot do this if location is aduseserver.
But do you know how could i do it without launching SQL query again, i mean, using the same recordset?


Thank you