I am using stored procedures (in IBM DB2) with Crystal Reports XI to create reports.
When I run the report from Crystal Reports, it runs fine for the first time.
But second time onwards I get an error message (SQL 901) saying “Cursor is already open”.
It seems I am missing some setting in the ODBC connection.
Any idea what are settings required or how this can be fixed?
And are there any options to return result set other than through cursor (which might fix my issue) ???
If Yes, then which is better as far as performance is concerned???
When I run the report from Crystal Reports, it runs fine for the first time.
But second time onwards I get an error message (SQL 901) saying “Cursor is already open”.
It seems I am missing some setting in the ODBC connection.
Any idea what are settings required or how this can be fixed?
And are there any options to return result set other than through cursor (which might fix my issue) ???
If Yes, then which is better as far as performance is concerned???