Problem with FireDac and Multithreading

0

Hi,

I use this version of FireDac v 8.0.5.3365 (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

 

Armindo

  • Accepted Answer

    Tuesday, June 20 2017, 03:56 AM - #Permalink
    0

    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

    http://docwiki.embarcadero.com/RADStudio/Berlin/en/Multithreading_(FireDAC)

    Read this very carefully !

    Regards, Roger

    The reply is currently minimized Show
  • Responses (2)
    Your Reply

    Please login to post a reply.........