02-06-2020, 02:35 AM
Soren,
In answer to your basic question, ADO is NOT thread safe. It works great if you keep the ADO pieces within each session, or you can pool it. I've played with pooled connections but haven't used them myself.
Put your ADO components on session forms or, for persistence during a session, on a datamodule that you then put on UserSession datamodule.
Regardless of where you put the ADO components, you should set the ComInitialization property of ServerController to ciMultiThreaded. This setting is needed if you use any COM component, not just ADO.
Dan
In answer to your basic question, ADO is NOT thread safe. It works great if you keep the ADO pieces within each session, or you can pool it. I've played with pooled connections but haven't used them myself.
Put your ADO components on session forms or, for persistence during a session, on a datamodule that you then put on UserSession datamodule.
Regardless of where you put the ADO components, you should set the ComInitialization property of ServerController to ciMultiThreaded. This setting is needed if you use any COM component, not just ADO.
Dan