Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
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 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 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.

 

Resolution

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.

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

Comments