Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

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


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:


Excerpt text from error message:

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


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.


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:

You can download Microsoft SQL Server Native Client 2012 driver here:


Was this article helpful?
0 out of 0 found this helpful