I cannot connect my Robot to MS Access in local PC where AppianRPAagent.exe exists.I am getting an error message "No suitable driver found for jdbc:ucanaccess://C:\AppianRPA\AppianRPARbot-CustomJavaCode\UcanAccess\AccessFile\targetDB.accdb".
However, after implementing JDBC using the same connection string When java is executed on eclipse, to connect to MS Access is successful without issue.So I think the connection string is correct.
In this case, I think there are two main reasons.-1. The external jar required to run JDBC has not been built to Appian. By the way, I'm using a library called "ucaccess".-2. In the first place, Appian RPA cannot access local files by design.
I have two questions about 1.・Is the external jar unusable in Appian RPA?・Is there a way to check if the external jar is built correctly?
I have a questions about 2.・Is this inference correct?
If you know of any possible reasons other than the above, please let me know.
Thank you.
Discussion posts and replies are publicly visible