SQL Passthru with MS SQL 6.5

Oliver SAue

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

SQL Passthru with MS SQL 6.5

Hi there,

I have a database on MSSQL 6.5 with two different tables. In D4 C/S I try to
query these tables
with a database component and two queries connected to it. If I activate the
first, everything is fine but trying to activate the second results in an
error like "Link already in use" . The native driver is set to SQL
Passthru="Not shared". The queries are very simple like "select * from this
order by that". Using "Share Autocommit" works but is processed locally so
the whole data ist transferred to the client.
Do I have to take another database component for each query ???

THX for any suggestions

Oliver Sauer
Berlin

Tomislav Kard

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Passthru with MS SQL 6.5

Hi Oliver!

On Sun, 20 Feb 2000 23:26:35 +0100, "Oliver SAuer" <sa...@sauer.de>
wrote:

Quote

>I have a database on MSSQL 6.5 with two different tables. In D4 C/S I try to
>query these tables
>with a database component and two queries connected to it. If I activate the
>first, everything is fine but trying to activate the second results in an
>error like "Link already in use" . The native driver is set to SQL
>Passthru="Not shared". The queries are very simple like "select * from this
>order by that". Using "Share Autocommit" works but is processed locally so
>the whole data ist transferred to the client.
>Do I have to take another database component for each query ???

You can have only one open cursor per database connection, so if you
want that first TQuery is not fetched all when the second opens up
then you have to uze another TDatabase component.

tomi.

Oliver Saue

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Passthru with MS SQL 6.5

Hi Tom,

thanks for the tip!
I didn't found it in any documentation.
It sounds like a bug, not a feature...

Oliver

Tomislav Kardas <nomail@sorry> schrieb in im Newsbeitrag:
38b3f623.14387...@forums.inprise.com...

Quote

> Hi Oliver!

> On Sun, 20 Feb 2000 23:26:35 +0100, "Oliver SAuer" <sa...@sauer.de>
> wrote:

> >I have a database on MSSQL 6.5 with two different tables. In D4 C/S I try
to
> >query these tables
> >with a database component and two queries connected to it. If I activate
the
> >first, everything is fine but trying to activate the second results in an
> >error like "Link already in use" . The native driver is set to SQL
> >Passthru="Not shared". The queries are very simple like "select * from
this
> >order by that". Using "Share Autocommit" works but is processed locally
so
> >the whole data ist transferred to the client.
> >Do I have to take another database component for each query ???

> You can have only one open cursor per database connection, so if you
> want that first TQuery is not fetched all when the second opens up
> then you have to uze another TDatabase component.

> tomi.

Other Threads

1. MS-SQL 6.5 & MS-SQL 2000

2. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

3. D2 SQL Links and MS SQL Server 6.5

4. Migrating MS/Sql 6.5 to SqL 7.

5. A good book on SQL (for MS SQL Server 6.5)

6. MS SQL Server 6.5/Delphi 1/SQL Links/Batch Move Problems

7. SQL Links for MS SQL 6.5 - Can't use dates

8. MS SQL 6.5 vs Local SQL Query

9. Installing sql-links for MS sql server 6.5

10. D4/sql 6.5 to D5/sql 6.5 creates Tstoredproc error