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: 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