Error: connection is busy with results for another hstmt

Good Afternoon. I have a Crystal report that accesses a sql 2000 server. W
hen I run the report twice with the same parrameters. I get the following e
rror:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and something
to the effect that my report is not consuming everything and therefore leavi
ng a cursor.
And while I understand that for the most part, I can't even begin to think h
ow to troubleshoot the report and find the problem. It's a HUGE report with
excess of 30 subreports. It is designed to only return 1 record, with nume
rous fields from throughout
the database placed on the report. Like I said it has numerous subreports,
and all are linked to the same URN. Anyway, is there anything I can do shor
t of upgrading the server to 2005?
From http://www.developmentnow.com/g/111...server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comafter nearly 30 hours of searching, I finally posted my question here.
What's funny is that 2 hours later I found my answer:
http://support.microsoft.com/kb/173410
From http://www.developmentnow.com/group...
=995268
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com