Board index » delphi » Connection is busy and SQL Server 7.0

Sergio Sanchez

Delphi Developer
Mon, 30 Jun 2003 08:05:52 GMT

Connection is busy and SQL Server 7.0

Hi All,

I have some applications developed in Delphi Enterprise and SQL Server 7.0
using a DataModule and TTables. I'm starting to get annoying "Connection is
busy with results for another hstmt" error message when switching from one
form with one table to another.

Could anyone please provide any help??,  Im really desperated and users
really angry.

--
Ing. Sergio H. Snchez Z. / ASESOFT Corporation
ssanc...@asesoft.com.mx
http://www.asesoft.com.mx

 
Eko Subagi

Delphi Developer
Tue, 01 Jul 2003 05:23:15 GMT

Re:Connection is busy and SQL Server 7.0


Thats because the connection still waiting for another result for
current query in current form, then when move focus to the another
form with the same query connection it will produce error,

i have found the same error, then i force with the scroll navigation,
before moving to the another form, it guarantee that the process of
connection is closed.

you can use move by, or something next, prior to force it.

Regards
Eko Subagio
www.delphi-jedi.org
www.geocities.com/ekosbg

Quote
"Sergio Sanchez" <ssanc...@asesoft.com.mx> wrote in message

news:93itdd$9e110@bornews.inprise.com...
Quote
> Hi All,

> I have some applications developed in Delphi Enterprise and SQL Server 7.0
> using a DataModule and TTables. I'm starting to get annoying "Connection
is
> busy with results for another hstmt" error message when switching from one
> form with one table to another.

> Could anyone please provide any help??,  Im really desperated and users
> really angry.

> --
> Ing. Sergio H. Snchez Z. / ASESOFT Corporation
> ssanc...@asesoft.com.mx
> http://www.asesoft.com.mx

Sergio Sanche

Delphi Developer
Tue, 01 Jul 2003 00:46:33 GMT

Re:Connection is busy and SQL Server 7.0


You are a real Genius!!, I just tried that and it worked just fine, Thanks a
lot!! I'll do some extensive testing.

Best Regards,
Sergio Sanchez

Quote
"Eko Subagio" <eko...@cbn.net.id> wrote in message

news:93jj7h$rfu3@bornews.inprise.com...
Quote
> Thats because the connection still waiting for another result for
> current query in current form, then when move focus to the another
> form with the same query connection it will produce error,

> i have found the same error, then i force with the scroll navigation,
> before moving to the another form, it guarantee that the process of
> connection is closed.

> you can use move by, or something next, prior to force it.

> Regards
> Eko Subagio
> www.delphi-jedi.org
> www.geocities.com/ekosbg

> "Sergio Sanchez" <ssanc...@asesoft.com.mx> wrote in message
> news:93itdd$9e110@bornews.inprise.com...
> > Hi All,

> > I have some applications developed in Delphi Enterprise and SQL Server
7.0
> > using a DataModule and TTables. I'm starting to get annoying "Connection
> is
> > busy with results for another hstmt" error message when switching from
one
> > form with one table to another.

> > Could anyone please provide any help??,  Im really desperated and users
> > really angry.

> > --
> > Ing. Sergio H. Snchez Z. / ASESOFT Corporation
> > ssanc...@asesoft.com.mx
> > http://www.asesoft.com.mx

Tomislav Kard

Delphi Developer
Wed, 09 Jul 2003 00:20:43 GMT

Re:Connection is busy and SQL Server 7.0


Hi Eko!

On Thu, 11 Jan 2001 13:23:15 -0800, "Eko Subagio" <eko...@cbn.net.id>
wrote:

Quote
>i have found the same error, then i force with the scroll navigation,
>before moving to the another form, it guarantee that the process of
>connection is closed.

>you can use move by, or something next, prior to force it.

What you need here is FetchAll (a member function of TQuery). It
brings all the records from the server localy and makes connection
free for new data fetch.

Moving to the last record actualy makes fetch all, but the real
solution is to call FetchAll method, at least that will keep the focus
to the current record intact.

tomi.

Other Threads

1. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

2. Connection is busy and SQL Server 7.0

3. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

4. MS SQL Server - Connection busy-- what gives?

5. Exclusive connection to MS SQL Server 7.0

6. SQL Server 7.0 connection

7. Connection with SQL Server 7.0

8. Sql Server 7.0 connections

9. Open connections with TTable-components to SQL - server 7.0 during runtime

10. DE problem with connection on SQL Server 7.0 without connect to the NT Lan