Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Error: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found


Issue

Under certain conditions, an error may be displayed when testing a Jet Remote Data Service (JRDS) data source.

If the data source is accessing a JRDS installed on a server with the Dynamics NAV database, Microsoft IIS, and SQL Server 2012, the following error may be displayed:

"Unable to load DLL 'SQLLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"

Cause

While the SQL Sever Native Client 2012 and Visual C++ Redistributable drivers used for connecting to the SQL database may be on the local system where the Jet Excel Add-In and Excel are installed, those drivers are not present on the servers themselves.

 

Resolution

A system administrator will need to install the Microsoft SQL Server 2012 Native Client and Microsoft Visual C++ drivers on the server containing IIS, SQL Server, and the Dynamics NAV database.


You can download Microsoft Visual C++ Redistributable driver here: https://www.microsoft.com/en-us/download/details.aspx?id=48145

You can download Microsoft SQL Server Native Client 2012 driver here: https://www.microsoft.com/en-us/download/details.aspx?id=50402

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments