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:

Excerpt text from error message:

Unable to load DLL 'SQLite.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