07-29-2019, 09:20 PM
There are no problems associated with ADO and services. Whoever told you that is not sticking to the facts.
I've used ADO in dozens of services working flawlessly 24x7.
Any service needs to be properly configured. The account which runs the service very likely has different privileges and might not have access to all needed resources. If you have an AV opening ADOConnection you need to check:
- How is your ServerController.ComInitialization setting (try Multithread and see if it works)
- If the account running the service has sufficient privileges to connect to the database.
I've used ADO in dozens of services working flawlessly 24x7.
Any service needs to be properly configured. The account which runs the service very likely has different privileges and might not have access to all needed resources. If you have an AV opening ADOConnection you need to check:
- How is your ServerController.ComInitialization setting (try Multithread and see if it works)
- If the account running the service has sufficient privileges to connect to the database.