Thread safe

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
QwiqBart
Posts: 5
Joined: Tue 04 Apr 2006 21:02

Thread safe

Post by QwiqBart » Tue 04 Apr 2006 21:09

Hi,
We are planning to create a second thread in our application because we excute sql's that result in 100's of thousands of records inserted in the database. According to the Delphi helpfile, the dbExpress data access components are thread safe, provided the vendor client library is thread safe. Is this the case for dbexpsda.dll ?
Thanks !

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Wed 05 Apr 2006 08:34

dbExpress driver for SQL Server is thread-safe and you can use it in multithread applications.
However, there is a restriction. The same connection cannot be used in several threads. So if you have multithreaded application it should have its own connection set for each thread that uses DbxSda.

Post Reply