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...

Hi,
I would like to know ways of editing the cache duration. I do not know how long the server cache would be persistant.
My server has got IIS 6.0 and somebody told me that i can achieve that by adding a node to the Meta Base.xml file.

I would like to know the syntax for the same or any possible alternative approach. My application is built on C# .Net.

Any code fragment/pointers would be really helpful....