ADO Threads and Connection Pooling

From: Simon Hooper (simon_at_simonhooper.co.uk)
Date: 01/06/04 

Date: Tue, 6 Jan 2004 16:52:46 -0000

What does the statement "ADO is thread safe" actually mean?

I want to create a multi-threaded data processing application. Probably
main plus three threads, all accessing the same SQL Server database.

Am I best to have one universal TADOConnection that all the threads use, or
do I need a separate TADOConnection created in each thread.

If I do need a TADOConnection per thread, how do I invoke connection
pooling?

Thanks in advance
Simon

Relevant Pages

  • simultaneous read/write using ado
    ... I'm writing a delphi program that writes a dbf file using ado. ... I'm using TADOConnection and TADOCommand. ... I want to execute two programs that read and write simultaneously in the same dbf file. ... Do I need to build some security to avoid a corrupt database or is this taken care of in the ADO component? ...
    (microsoft.public.data.ado)
  • Re: Ado, Threads (and videotape)
    ... > I protect the attributes with a TMultiReadExclusiveWriteSynchronizer. ... > Access BD (using ADO). ... You can have only one TADOConnection for it. ... TADOConnections has sense, for example, if you need to connect to multiple ...
    (borland.public.delphi.database.ado)
  • Re: Calling the ConnectionString Creator dialog
    ... >TADOConnection, clicking in the ConnectionString property you can bring up a ... I'm sure this is just the ADO dialog from micorsoft, ...
    (borland.public.delphi.database.ado)
  • Re: trivial (or not?) question about MSAccess login
    ... Create a new datamodule. ... Drop a TADOConnection on it from the ... ADO page of the component palette. ...
    (alt.comp.lang.borland-delphi)