A stored procedure that was previously working under Win 95 / Crystal Reports 7 is now not working under Windows 2000 Professional with Crystal Reports 8.5!
The error message "ODBC SQL Server Driver - Invalid Cursor State" appears when I try to run the reports using this particular stored procedure.
My other stored procedures still work. The main difference between the working and non-working procedures is that the latter does not use an explicit cursor and contains a series of IF statements. The procedure that still works uses a temp table and an explicit cursor.
If I try to create a new report using the non-working procedure, it retrieves the data on the first refresh but comes up with the invalid cursor state error message on the next refresh.
Would appreciate comments.
Many thanks
Manuela
The error message "ODBC SQL Server Driver - Invalid Cursor State" appears when I try to run the reports using this particular stored procedure.
My other stored procedures still work. The main difference between the working and non-working procedures is that the latter does not use an explicit cursor and contains a series of IF statements. The procedure that still works uses a temp table and an explicit cursor.
If I try to create a new report using the non-working procedure, it retrieves the data on the first refresh but comes up with the invalid cursor state error message on the next refresh.
Would appreciate comments.
Many thanks
Manuela