Error when running queries

If you're using BDE, the connection must be "shared [no]autocommit".
Open bde administrator and check this option.
Otherwise, read the manual.
Also, see my other message "Re: Error with SQL Server"

Robert Cerny
Remove both qwe when replying

No questions via email, unless explicitly invited.

Nina Gaspar wrote in message <>...
>I am using Delphi 5 and MS SQL 7 through ODBC.
>In my application I am running a process were I run a query and then I
>do a While Not(EOF) for that query.  In that loop I am running few other
>queries to get and update data.  The original query that I am iterating
>through have about 3000 to 4000 records.  After running about 80 records
>I get the following error:

>SQL Error: SQL Server - [Microsoft][ODBC SQL Server Driver]Connection is
>busy with results for another hstmt

>I don't remember having this problem before switching to MS SQL Server.
>Any suggestions of what I could do to avoid this problem.

>Any help will be greatly appreciated.
>Thanks. in advance.