VB Forum / Database Access / January 2008

I have a stored procedure on a SQL server 2005 database. Application
accessing it is a VB6 program. The app returns the records fine. What
I would llike to do is after the recordset gets returned is to resort
it to one of the columns returned. Data is currently being sorted from
stored procedure by order date. It being a stored procedure, that is
being used by several different apps, I can't change it on server.
I have defined recordset CursorLocationto be adUseClient
This is the two lines setting recordset (in this case rsNotPicked)

rsNotPicked.CursorLocation = adUseClient
rsNotPicked.Open m_cmdQuery, , adOpenStatic, adLockReadOnly
'EXECUTES the stored procedure

At this point I can step through records with

Do While Not rsNotPicked.EOF
   MsgBox rsNotPicked.Fields("item Description")
   rsNotPicked.MoveNext
Loop
The message box is the field I would like to resort by

when I try to execute
rsNotPicked.Sort = "item description ASC"

I get error Run-Time 3001
Arguments are of the wrong type, are out of range,or are in conflict
with one another.
I can use the sort method with simple select statements, but using the
stored procedure recordset I am struggling with.

ANy help would be most appreciated.