You should be able to avoid this problem using server-side cursors.
MCSD, SQL Server MVP
I am using SQL Server 7.0 with ODBC.
I'd like to know if I call a stored procedure from C++
does it return the results set by default unless I specify
to user server cursors or vice versa?