Error with OLEDB Action in Blue Prism 7.3.0

[nikhiln]

Hello everyone,

I am currently using Blue Prism Trial version 7.3.0 on a stand alone machine and encountering an issue while trying to access an OLEDB action. The error message I receive is:

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

Below is the connection string we are using

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[Data source]&";Extended Properties=""Excel 12.0 Xml; HDR=YES;"""

Here are some additional details:

Operating System: [Windows 10]
Blue Prism Version: 7.3.0
Has anyone else faced this problem and found a solution?

Thanks

Nikhil

[MichealCharron]

@nikhiln 

You might want to check which ACE OLEDB driver and what BP 7.3 you have installed. Both the ACE OLEDB driver and BP 7.3 come in 64-bit and 32-bit versions. You can't run the ACE OLEDB 32-bit driver with the BP 7.3 64-bit software and vice-versa.

[Mohamad_747]

Hi @nikhiln 

If you are trying to read a csv file then :

Try to use the last version of Vbo

Utility file management here : https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---file-management

After this install Microsoft access database engine from here :  http://www.softsea.com/download/Microsoft-Access-Database-Engine-32-bit.html

After this try to run your action 🙂

Regards

[MichealCharron · Accepted solution]

BTW, to check if you are using a 64-bit version of Blue Prism. Click the "?" (1) at the top right of the main screen and then select the "About" option (2). You should be able to see the x64 if you are using the 64-bit version.

[michaeloneil]

Hi Nikhiln

Do you have MS access installed on your machine? usually if you are trying to connect using this connection string to excel files you might also need access installed. Also just on your connection string "Excel 12.0 Xml" you can remove the xml so its "Excel 12.0".

Other than that as MichaelCharron mentioned you should check you are using the same version of the oledb connection components as you are Blueprism.

[bruce.liu · Accepted solution]

Hi Nikhiln,

Please kindly check this KB article.

If you install 64bit BP v7.2 or above, you must install 64bit version Microsoft Access Database Engine Redistributable 2016 before you can invoke ACE OLEDB 12.0. If you have been running 32bit version of Microsoft Office before upgrading to 7.2 or above, you should uplift it to a 64bit version also. Failing to do so, you will find potential conflicts in having 64bit version of Microsoft Access Database Engine Redistributable 2016 and 32bit Microsoft Office in the same environment - one may simply block the other from being installed successfully. There exists certain workaround but it is not a recommended setup by the vendor of those products - Microsoft, and there is no guarantee such workaround will always work.

If you install 32bit BP v7.2 or above, you must install 32bit version of Microsoft Access Database Engine Redistributable 2016 before you can invoke ACE OLEDB 12.0. 32bit Microsoft Office is required so it can be installed alongside with 32bit version of Microsoft Access Database Engine Redistributable 2016.

The official URL for Microsoft Access Database Engine Redistributable 2016 is at https://www.microsoft.com/en-us/download/details.aspx?id=54920. accessdatabaseengine_X64.exe is the 64bit version, whereas accessdatabaseengine.exe is the 32bit version.

Hope it helps.

[nikhiln]

Hi Everyone , Thank you and appreciate your time for the quick responses

Seems Like the currently installed , Microsoft Access Data Base Engine 2010 was 32 bit version , and the version of Blue Prism Trial edition installed is 64 Bit 

This works after removing the 32 bit Access Database Engine and replacing with the 64 Bit one

Thanks

Nikhil