I've spent hours on trying to have Azure Data Factory read the onprem Access Database. I've also made the file read/writeable by everyone, I guess that should include "NT Service\DIAHostService". I wasn't able to find anything in integrationruntime logs either. Also, the "Test Connection" in integrationruntime was no success, tried with escaping "" with "\", no luck. IntegrationRunime is working just with local SQL Database, but I can't get the Access file to work. Any idea why? Or how to debug?
Asked
Active
Viewed 122 times