ADODB Recordset Update

Hi:
I have the following piece of code which works well under SQL Server 6.5. But it gives a "Cursor is Read Only" error at the Update statement under SQL Server 7.0.

Set rsheader = New ADODB.Recordset
rsheader.Open strSQL, cnnODBC, adOpenDynamic, adLockOptimistic
Do While Not rsheader.EOF
rsheader.Update "Status", "P"

' more code here

rsheader.movenext
loop

Could somebody let me know what is wrong in the above code?
Thanks.

[Steve Thomas]

I don't know for sure but I have had the same types of problems with SQL (7.0). You might want to try and change the CursorLocation. There are two settings adUseClient and adUseServer. I would try and change this and see what happens. I am finding however, that sometimes you lose the ability to use the AbsolutePosition and RecordCount when CursorLocation is not set properly.

The other thing you might try is a different Provider to connect to the Server. Some providers behave differently.

I changed the value of recordset.CursorLocation from the default adUseServer to adUseClient and that solved my problem.