Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is Delphi's TADOConnection thread-safe?

I'm writing a Delphi 7 application which needs to access the same SQL Server database from many different threads simultaneously.

Can I use a single shared TADOConnection, or must each thread create their own?

like image 631
Blorgbeard Avatar asked Aug 06 '09 22:08

Blorgbeard


2 Answers

Blorgbeard, you must create, initialize and open a separate TAdoconnection instance for each of your threads.

ADO is a COM-based technology. It uses apartment-threaded objects ,don't forget to call CoInitialize(nil).

procedure TMyThread.Execute;
begin
   CoInitialize(nil);
   try
     try
       // create a connection here
     except
     end;
   finally
     CoUnInitialize;
   end;
end;
like image 149
RRUZ Avatar answered Nov 10 '22 13:11

RRUZ


No, it is not. ADO is a COM-based technology. It uses apartment-threaded objects, thus you cannot use ADO connections across thread boundaries. Each thread need its own connection.

like image 10
Remy Lebeau Avatar answered Nov 10 '22 13:11

Remy Lebeau