Good afternoon,
I took a component from the article
As long as the expert Advisor with the loaded component is on one or two charts , there are no problems.
As soon as I connect the third and further – errors begin to pour.
It seems that when loading the component for the third time, the previously loaded one is used.
Can you tell me how to deal with errors and achieve stable performance regardless of the number of expert advisors on the chart?
I have so far only thought to pull the REST service from 1C and merge the data into the 1C database. Or a service in Python and through the layer in Python merge into MS SQL. But I would like without layers..
nektomk
Errors actually need to be checked 🙂
you have the first “Connection is null”, everything else is obvious.
and it is necessary from C#(and in General from all DLLs) to pull out all possible diagnostics for errors
you can try to stick a CritcalSection around calls-perhaps the MSSQL init is somehow incorrectly made and is not suitable for multithread. If it helps, then somehow it is necessary to explain that multiple connections are possible from different threads
PS / by the way, why sharp and MSSQL? judging by the Outlook-more direct solutions are possible (C/C++ DLL, MySQL or even Oracle-their interfaces are not so @ # nutty)
PPS / periodically I look out of the corner of my eye at 1C-almost the only ERP more or less available. In principle, the bridge to it would be steep 🙂