ADO, SQLOLEDB and the ORDER BY clause

[Lozzer]

I am trying to open a static, pessimistic locking recordset on a SQL 7 server which needs some record deletions.

I need also to order the recordset and have been trying to do so by using an order by clause in the SQL statement in the open method of the recordset.

If I remove the ORDER BY clause the recordset opens fine.

If I use the ORDER BY clause, the recordset returned is always read only and forward only!!

Does anyone have any ideas how to get around this problem??
PLEASE HELP!!