Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems
search cancel

Error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" on x64 systems

book

Article ID: 154945

calendar_today

Updated On:

Products

IT Management Suite Client Management Suite Server Management Suite

Issue/Introduction

When creating a Data Connector Data Source using an excel spreadsheet (.xls or .xlsx), following error is seen.

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Environment

ITMS 8.x

Cause

The dll mentioned in the error must be registered on the notification server (NS).  This dll is installed with Office 2010 and later but must be the x64 edition of MS Office when installed on a 64-bit server.

Resolution

There are two methods to resolve this issue.

  • Install MS Office 2007 x64 or later x64 version of MS Office. 
  • Alternately Microsoft provides an executable that will install the needed files without the need to install MS Office on the SMP.   Note: In the event that the download location becomes unavailable the name of the file is Access Database Engine 2010 Redistributable and could be searched on Microsoft's download site.