The command "recordset.sort" not work in .Net Environment

[ejanakieff]

I'm working with Visual Basic .Net.

I have making a component that acces to a data base with .Net Dataproviders, returns the result in a DataSet, and then I pass the content of the DataSet to a Recordset, finally this recordset is send to an asp based web application.

In the Visual Basic .net I have Add a Reference to the adodb.dll (I tried with :.Net assembly and with Microsoft ActiveX DataObjects 2.7 Library), because I need use recordset object.

I want to sort this recordset in the asp pages. So, in the component, before to open the recordset I put the CursorLocation=adUseClient.
But when I sort the recordset at the asp pages only works fine if I sort by a key field, no by other field.

When I use a component make with Visual Basic 6.0, this works fine.

Somebody knows the reason it doesn't work if I return the recordset by a component made with Visual Basic .Net?

Thanks,
Eva Janakieff