Multiple connections opened to MS SQL 6.0

Pedro Garcia Dieguez

Delphi Developer

Mon, 12 Oct 1998 03:00:00 GMT

Multiple connections opened to MS SQL 6.0

Whenever I open a Ttable one more connection to the SQL Server is added.
It remains opened until I close the table. I have read in this
newsgroup an answer to somebody that had the same problem, and the
advice was to connect to a TDatabase instead of using alias. I have
tried this, and if I use TQuery and connect to a TDatabase, only one
connection is opened, but this doesn't work with tables.
Some ideas?

Simon Mun

Delphi Developer

Fri, 16 Oct 1998 03:00:00 GMT

Re:Multiple connections opened to MS SQL 6.0

In article <317FD05F.6...@bitmailer.net>, Pedro Garcia Dieguez <pe...@bitmailer.net> wrote:

Quote

>Whenever I open a Ttable one more connection to the SQL Server is added.
>It remains opened until I close the table. I have read in this
>newsgroup an answer to somebody that had the same problem, and the
>advice was to connect to a TDatabase instead of using alias. I have
>tried this, and if I use TQuery and connect to a TDatabase, only one
>connection is opened, but this doesn't work with tables.
>Some ideas?

As far as I know, Delphi doesn't use bi-directional cursors to MS-SQL.
Therefore, the BDE is using SQL queries to get the data anyway. If that is
the case, you might as well use TQueries anyway. You'd have to run some
benchmarks to test it tho.

Cheers, Simon

Other Threads

1. Multiple connections with MS SQL

2. Multiple MS SQL Connections, Delphi 3

3. Interbase 6.0 and IBX freeze when opening two connections in the same time

4. SQL 6.0 connections and Delphi

5. opening ADO connection spawns multiple threads

6. Delphi, Banyan, Windows 95, and MS SQL Server 6.0

7. Live result set - MS SQL 6.0

8. Sybase driver and MS-SQL 6.0 - HELP!

9. D2 and MS SQL 6.0

10. MS SQL 6.0/Create Database?????