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

SYMPTOMS

When utilizing the eDiscovery Bundle Database Collector and you want to collect a Microsoft Excel file or a workbook file you observe that the database collection action gives error "Opening connection failed ---> The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

CAUSE

This may be caused by a missing Microsoft Access Database Engine 2010 Redistributable on all the processing nodes.

RESOLUTION

From Microsoft:
"This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats."

Visit: http://www.microsoft.com/en-us/download/details.aspx?id=13255 for more details.

Ensure this download is installed on all processing nodes in your cluster.

APPLIES TO

3.7 Service Pack 1