MSSQL 6.5 D 3.01 Too many connections!!!

Ronen Kerti

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

MSSQL 6.5 D 3.01 Too many connections!!!

Hi All

We have developed a system in Delphi 3.01 using BDE 5.0 and working with
MSSQL 6.5. The
system is based upon TTables components, which all are connected to the
DataBase through
ONE TDataBase component.
Despite Delphi's help, declaring that using one TDataBase result in one
connection, we noticed
that there are many connections (approximately one for each TTable). We
also noticed that even
when closing the TTable and freeing it, the connections is still there
in "Sleeping" status.

If someone of you there know how to reduce the amount of connections, we
will really appreciate it, since we can't deploy the system as a result
of all of those connections.

Thanks in advance,

Ronen Kertis.

P.S. We know that TQuery does not cause this problem, but this is not an
option for us to
convert the system to use TQuery.

Terr

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 6.5 D 3.01 Too many connections!!!

Why is it not an optioin for you to convert this system to TQueries?

On Sat, 15 Aug 1998 17:45:12 +0300, Ronen Kertis

Quote

<rone...@netvision.net.il> wrote:
>Hi All

>We have developed a system in Delphi 3.01 using BDE 5.0 and working with
>MSSQL 6.5. The
>system is based upon TTables components, which all are connected to the
>DataBase through
>ONE TDataBase component.
>Despite Delphi's help, declaring that using one TDataBase result in one
>connection, we noticed
>that there are many connections (approximately one for each TTable). We
>also noticed that even
>when closing the TTable and freeing it, the connections is still there
>in "Sleeping" status.

>If someone of you there know how to reduce the amount of connections, we
>will really appreciate it, since we can't deploy the system as a result
>of all of those connections.

>Thanks in advance,

>Ronen Kertis.

>P.S. We know that TQuery does not cause this problem, but this is not an
>option for us to
>convert the system to use TQuery.

Richard Proudfoo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL 6.5 D 3.01 Too many connections!!!

Ronen,

I haven't heard of anyone really solving this problem.

Why is using TQuery not an option?

Regards,
Richard

Other Threads

1. Configuring the MS SQL Server 6.5 driver with the BDE Administrator (Delphi 3.01)

2. Trusted Connection on Mixed MSSQL 6.5

3. Connections with MSSQL Server 6.5 and Delphi2

4. HELP: D3 - MSSQL 6.5 - number of user connections.

5. How to force the BDE to close all connections to MSSQL 6.5

6. MSSQL 7.0 x MSSQL 6.5 (Inserted, Deleted)

7. Delphi 3.01, MSSQL, and Multi-protocol

8. Delphi 3.01 C/S and MSSQL

9. Announce: TCompress 3.01, TSegCompress 3.01

10. MSSQL 6.5 "Query Canceled"