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

asked on December 14, 2022

In trying to use a CSV as a Data Source for a Business Process in Laserfiche Cloud on the Integrations > Data Sources > [DATA_SOURCE_NAME] > Edit Data Source page trying to Verify the settings (below) and I am receiving this error message:

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

I have googled this error and found suggestions to install:

Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-au/download/details.aspx?id=13255)
Microsoft Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=54920)
Microsoft Data Access Components (MDAC) 2.8 Software Development Kit (https://www.microsoft.com/en-us/download/details.aspx?id=21995)

I have also restarted the computer that has the remote worker set up. I have a SQL data source on that same computer and it works fine so I know the most of the rest of my setup is configured correctly.

My Data Source settings:

Edit Data Soure

Name: CSV Test

Description: This is a test.

Type: CSV

Remote Agent: Test Remote Worker

Server: localhost

CSV folder path: C:\test\test.csv

Any ideas?

0 0

SELECTED ANSWER

replied on December 14, 2022

Currently, by default csv data query uses Microsoft.ACE.OLEDB.12.0 for 64-Bit OS and Microsoft.Jet.OLEDB.4.0 for 32-Bit OS for Oledb provider.

When debugging CSV-type data query rule locally, you may get this error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine., even if you have 12.0 installed.

Solution:
Install both 64-Bit and 32-Bit version of Microsoft Access Database Engine 2010 Redistributable

Download 64-bit version from https://www.microsoft.com/en-us/download/details.aspx?id=13255
Download 32-bit version from https://www.microsoft.com/en-us/download/details.aspx?id=13255
A normal attempt to install 32-bit version should fail because you have 64-bit installed already.
Use /passive to install
Delete or rename the mso.dll registry value in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths

Reference:
https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

1 0

replied on December 14, 2022

This is great thank you. It got me passed the error I orginaly posted but now I'm getting:

'C:\test\test.csv' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Is there certain permissions needed, or is there a different path that I need to use?

0 0

replied on December 14, 2022 • Show version history

It's the directory path (not include the csv file) provide to data source creation dialog

Then the csv file name would be treated as `table` name in the query UI.

`city.csv` under above directory would be in available tables

0 0

replied on December 15, 2022

Perfect, that works!

Sidenote: As a suggestion (if you have a way to pass it on to the people that be), I know it should be clear/obvious having the field titled "CSV folder path" but I would think if the user inputs somthing.csv the system should notice and suggest removing the file from the path. But maybe I'm just an outlier on this one.

Thanks so much for your help!

1 0

Question

Question

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

Answer

Replies

Sign in to reply to this post.