0

Jet Essentials DB Communication Error [SOLVED]

Jet Reports Historic Posts

September 24, 2015 20:54

None

Follow

Hi Everyone,

I'm using jet essentials on office 365 excel and the sql db is linked with a crm nav 2013. The problem is strictly with a single workstation because other workstations are able to connect to the server to generate reports.
I am getting the following error below when trying to run a report using Jet Essentials and I do have the latest and required drivers under my ODBC data source: SQL Server Native Client 11.0

Provider cannot be found. It may not be properly installed.
System.Runtime.InteropServices.COMException
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at Jet.Data.Ado.AdoDataSource.a..ctor(String connectionString)

Thanks

• e1.png

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 25, 2015 15:46

  RESOLVED!
  
  I found and installed the original SQL client used on the server to match the exact version and removed all previous registry files prior to the install. Finally, I used the web service on Excel to communicate between JET and the DB, and it worked!

• 0
  
  Jet Reports Historic Posts November 16, 2015 23:47

  http://kb.jetreports.com/article/AA-01172/0/Essentials-error%3A-Provider-cannot-be-found.-It-may-not-be-properly-installed.html