Re: ADO thread safe?

From: "Fred" <fredrik.ahlen@xxxxxxxxxxxxxxx>
Date: Wed, 24 Jan 2007 13:38:30 +0100

Do remember that the ADO-wrapper (the VCL classes) in Delphi is not thread
safe but ADO itself is thread safe.

I do know this for sure since I have "patched" the VCL-wrapper myself due to
thread safe problems in a heavy loaded multi tier application.

/Fred

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> skrev i meddelandet
news:lefmo257pknk3fo11h34df1t5034div1mf@xxxxxxxxxx

I use ADO with Delphi 5 against an MS Access database. TAdoQuery and
TAdoTable connecting with TAdoConnection.

I'd like to have modal QuickReport previews. But according to the QR FAQ,
this only works, if the database is thread-safe (see below, I use the
PreviewModal method).

Is the ADO database driver thread safe

Yes
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx

Prev by Date: Re: "cannot perform this operation on a closed dataset"
Next by Date: DAO to ADO and stored procs
Previous by thread: sql join and lookup table question
Next by thread: DAO to ADO and stored procs
Index(es):
- Date
- Thread

Relevant Pages

Re: CreateInstance on ado object returns 0x80080008
... No, ADO is thread safe. ... What is happening is COM is shutting down inside the process, ... So I suspect your issue with mismatched CoInitialize/CoUninitialize calls ...
(microsoft.public.data.ado)
Re: D5+ADO+Threads
... You will also need to call CoIntialize / ... >CoUninitialize in each thread. ... ADO is thread safe but that does not change the fact that you can't share ...
(borland.public.delphi.database.ado)