ADO + MS SQL 2000 + threads

Damiano Curia

Delphi Developer

Tue, 30 Dec 2003 15:50:33 GMT

ADO + MS SQL 2000 + threads

I've written a program in Delphi 6 that creates a variable number of thread
and each thread creates an ADOConnection and executes two queries.
It seems that:
- I have not limit on simultaneus ADOConnection I can create (and obviusly
open);
- the simultaneus queries on the different connections run concurrently;
- to improve performance I don't need to cache ADOConnections, as they are
already cached by ADO itself.

Is all this real or I'm wrong in something?

Thanks, Damiano Curia

Brian Bushay Team

Delphi Developer

Wed, 31 Dec 2003 12:17:55 GMT

Re:ADO + MS SQL 2000 + threads

Quote

>- I have not limit on simultaneus ADOConnection I can create (and obviusly
>open);
>- the simultaneus queries on the different connections run concurrently;
>- to improve performance I don't need to cache ADOConnections, as they are
>already cached by ADO itself.

>Is all this real

Yes that is how you can use connections
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Jonathan Wilso

Delphi Developer

Tue, 06 Jan 2004 17:56:09 GMT

Re:ADO + MS SQL 2000 + threads

On Fri, 13 Jul 2001 23:17:55 -0500, Brian Bushay TeamB

Quote

<BBus...@Nmpls.com> wrote:
>>- I have not limit on simultaneus ADOConnection I can create (and obviusly
>>open);
>>- the simultaneus queries on the different connections run concurrently;
>>- to improve performance I don't need to cache ADOConnections, as they are
>>already cached by ADO itself.

>>Is all this real

>Yes that is how you can use connections

But I believe that licensing at the server _may_ be exceeded..

eg Server License =10 users

2 PC's running 2 programs with 5 connections = 10 users?

This _may_ not be a problem depending on the servers
(MSSQL/DB2/AS400/etc.) license restrictions.

If the server has a regulator that does not detect machines instead of
connections then it may reject connections &/or throttle back
responses.

However this is very provider specific.

Jon
--

Integrated 400 Solutions Ltd.

Jonathan Wilson, AS/400 consultant/director

24 Hours: 07775 638904

Justin Pitt

Delphi Developer

Fri, 16 Jan 2004 12:12:10 GMT

Re:ADO + MS SQL 2000 + threads

in re MSSQL, the licenses are counted per host connected to the server
(except middleware...another story...) so these connections will all use
only one license on MSSQL.

Quote

> But I believe that licensing at the server _may_ be exceeded..

> eg Server License =10 users

> 2 PC's running 2 programs with 5 connections = 10 users?

> This _may_ not be a problem depending on the servers
> (MSSQL/DB2/AS400/etc.) license restrictions.

> If the server has a regulator that does not detect machines instead of
> connections then it may reject connections &/or throttle back
> responses.

> However this is very provider specific.

> Jon
> --

> Integrated 400 Solutions Ltd.

> Jonathan Wilson, AS/400 consultant/director

> 24 Hours: 07775 638904

Other Threads

1. MS-SQL 6.5 & MS-SQL 2000

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

3. D5 + ADO + MS Sql 2000 = Unspecified Error

4. Delphi 5 - ADO - MS SQL Server 2000

5. ADo, MS SQL 2000 and Parameters

6. ADO, MS SQL 2000, CursorType ctDynamic and temp tables

7. DELPHI ADO & MS SQL 2000 Requery question

8. Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000

9. ADO MS-SQL 2000 Update

10. ADO, MS SQL 2000, CursorType ctDynamic and temp tables