Can't use sort property

[Shafee]

Why can't I use the sort property with ado recordsets in asp scripts? When I try, I get the following message:

ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

/historyresponse.asp, line 30

Why is this?

[Clunietp]

before you open your recordset, set the cursorlocation to adUseClient

example

dim objRS

const adUseClient = 3

set objRS = server.createobject("ADODB.Recordset")

objRs.CursorLocation = adUseClient
objRs.Open "Select * from MyTable", "<connectionStringHere>"

objRs.sort "myColumn"

'etc etc.....

Please note that this code is not entirely syntactically correct, as I whipped it off of the top of my head, but it should prove the point

Tom

[Shafee]

Thanks Clunietp. It worked great.