I cannot connect my Robot to MS Access in local PC where AppianRPAagent.exe exists.
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.
