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 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)"
While the SQL driver used for connecting to the SQL database may be on the local system where Jet Essentials and Excel are installed, that driver is not present on the server itself.
A system administration will need to install the Microsoft SQL Server 2012 Native Client on the server containing IIS, SQL Server, and the NAV database.