I'm in the process of testing the new SQL Server 2005 database with applications that are currently running against SQL Server 7. I have the following code (using RDO, rs = Recordset, qy = Query):

Code:
Set rs = qy.OpenResultset(rdOpenKeyset)

lngRowCount = rs.RowCount

Do Until rs.EOF
     '(code)
Loop
When I run this code against SQL Server 7, lngRowCount correctly shows 1 record and EOF = False. When I run it against SQL Server 2005, lngRowcount correctly shows 1 record, but EOF = True, which skips the loop, which doesn't populate the variables, which causes unexpected results, etc.

Is there a way this can be fixed without rewriting the code? My company wants to deploy SQL Server 2005 as soon as possible and it will take weeks or months to modify every place with similar code.

Any ideas? Thanks!