Hi all,
I am currently struggling to get past the following error message when firing off
several large queries to SQL Server 7.0:
"Connection is busy with results for another hstmt"
I am connecting using ODBC, Delphi 4 C/S on WinNT 4.0. A quick search on
Developers.href reveals many others who have encountered the same problem, but no
practical solutions. One approach is to use server side cursors, but we are executing
complex queries which do not meet the criteria for a server cursor (ie multiple
SELECTs in a statement).
Any suggestions most gratefully accepted.
On a related note, we have found that connecting to SQL Server 7 via the BDE with the
native driver supplied with D4 C/S is considerably (as much as 250%) slower than
accessing via the ODBC driver. Anybody noticing similar results, or have we missed
something major??
Cheers,
James.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
