Problem with FireDac and Multithreading
I use this version of FireDac v 18.104.22.16865 (28.05.13) with Delphi 2010.
We have bought Tolyo a few weeks ago but I have to keep a specific project with Delphi Delphi 2010.
I fave a strange behaviour.
I have made a Windows Service that you Firedac in Multithread, each threads has it's own Firedac connection and components.
When I call a Sopecific StoredProc with a TADStoredProc I get and FireDac Error :
[firedac][Phys][ODBC][Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active
All my triggers have a SETNOCOUNT ON at the Begining of each Triggers
but same problem.
But the very strange thing is that If I call the same Stored Procedure inside a simple delphi Project, that doesn't run in Multithread, I have no problem.
Should I set something special to FireDac to avoid this kind of problem ?
With best regards
Good morning Armindo,
I use FireDAC in a multi-threading project with lots of pooled connecitons - using C++ and VCL. It does work but you have to get everything correct as described at
Read this very carefully !
Thanks Roger and Djone.
Apply this script in your DB:
if (SELECT value
WHERE name = 'disallow results from triggers') = 0
exec sp_configure 'show advanced options',1
exec sp_configure 'disallow results from triggers',1