Dhaval,1 person found this helpful
You need a JDBC Access driver on the EDQ server. It is not possible to load data from files for which the drivers are not installed.
Have you tried both client-side and server-side data stores?
Thanks for the insight. My client and server is my local machine. That being said, I appreciate the insight that you had around using JDBC drivers. Upon more digging around trying to get JDBC drivers, I was able to find AccessDatabaseEngine.exe, which is required to access the MS Access DB. I guess, I was not having this issue on my other machine because I already have MS Access 2007 installed on that machine, whereas on this particular machine, I don't have it installed. With the installation of the 64-bit version of the AccessDatabaseEngine, I was able to resolve the issue.
We can consider this thread closed.
Thanks for your help!
Use AccessDatabaseEngine.exe (either 32bit or 64bit depending on your system build).
The suggestion to install the AccessDatabaseEngine is fine, unless you have a 64-bit machine with 32-bit MS Office installed (as MS recommends). Has anyone tried the workaround mentioned near the end of this thread? http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/abf34eea-1029-429a-b88e-4671bffcee76
Or found a better solution?
Installing the AccessDatabaseEngine_x64 (for 64-bit Windows 7 environments) only works if you have a 32-bit MS Office installation if you include /passive when doing the install as in this post. http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/abf34eea-1029-429a-b88e-4671bffcee76
Were you able to access the mdb file after installing the Access Database engine. I am still unable to do and it continues to give the same error.
Or is there a better solution to address this problem.
Is there an alternative solution for this problem. Even after installing the Access Database engine, the error persists.