Skip to main content
Brainy
Feb 22, 2023 9:08 AM UTC
Solved

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.

Brainy
Mar 7, 2023 8:29 AM UTC

This matter has been solved.

My RPA robot can connect MS Access

1 reply

motoyay3833AuthorAnswer
Brainy
Mar 7, 2023 8:29 AM UTC

This matter has been solved.

My RPA robot can connect MS Access