Connection failed RPC Exception: access denied

Q.Why can’t I connect to my Microsoft Access .mdb file using the Microsoft JDBC-ODBC Bridge?
Ans:
The problem is likely to be that the Microsoft Access .mdb file is on a mapped network drive that can only be accessed by a named user.
There are three possible solutions:

* Move the .mdb file to a drive that can be accessed by a service.
* Add the following attributes to the JDBC connection URL:
logonuser=username:logonpassword:password

Q.Why do I get error like “Connection failed RPC Exception: access denied (java.net.SocketPermission ip address/server name:8031 connect,resolve)” when trying to connect in the test applet using a fully qualified JDBC URL?
Ans:
Check the Datasource Urls and hostname provided for datasource.

Q.Why I’m getting below error while validating a query.

Ans:
Check the DATAACCESS and DBDRIVER parameters in configuration.
Check the datasource connectivity.
Check the datasource Url.

In case of any ©Copyright or missing credits issue please check CopyRights page for faster resolutions.