topic RE: Microsoft ACE OLEDB 12 in Product Forum

Microsoft ACE OLEDB 12

Mohamad_Dakkouri — Sun, 23 Jul 2023 11:05:00 GMT

Hi,

I have an issue.

I have a big Excel File and i am trying to use data oledb to make some sql query on it.

When i try to execute, i have this error message " Microsoft Oledb Ace 12 is not registred on my machine ". I tried to installa access engine but still not working. I searched on the internet (community etc...) But nothing worked for me do you have an idea ?

------------------------------
Mohamad DAKKOURI
------------------------------

RE: Microsoft ACE OLEDB 12

Devendra_KumarP — Mon, 24 Jul 2023 04:53:00 GMT

Hi @Mohamad DAKKOURI,

Try below and see if it work -

https://learn.microsoft.com/en-us/answers/questions/296080/how-to-fix-microsoft-ace-oledb-12-0-provider-is-no

------------------------------
Devendra Kumar Prajapati
RPA Manager
Infosys
Chandigarh, India
------------------------------

RE: Microsoft ACE OLEDB 12

ewilson — Mon, 24 Jul 2023 13:39:00 GMT

@Mohamad DAKKOURI,

Are you using the Data - OLEDB VBO from the Digital Exchange or one included with the BP installation? Are you passing in your own connection string or using the default value?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft ACE OLEDB 12

Mohamad_Dakkouri — Mon, 24 Jul 2023 18:56:00 GMT

Hi Eric,

I am using VBO from Blue Prism not from Digital Exchange.

I am using my own connection string.

It didnt work yet. I tried a lot of things, but nothing work

RE: Microsoft ACE OLEDB 12

ewilson — Tue, 25 Jul 2023 00:27:00 GMT

@Mohamad DAKKOURI,

What version of Blue Prism are you using? You said you tried installing the Access Database Engine redistributable. Did you use the 32-bit or 64-bit installer for that?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft ACE OLEDB 12

Mohamad_Dakkouri — Tue, 25 Jul 2023 13:55:00 GMT

Hi all,

I have Blue Prism 7.1.

I have used 64 bit.

Any suggestions ?

------------------------------
Mohamad DAKKOURI
------------------------------

RE: Microsoft ACE OLEDB 12

ewilson — Tue, 25 Jul 2023 15:06:00 GMT

@Mohamad DAKKOURI,

Ok. Prior to the release of Blue Prism v7.2, the Automate.exe client was a 32-bit application (even if you used the 64-bit BP installer). Because of that, you would need to use the 32-bit version of the Access Database Engine installer as a 32-bit application can't load/use a 64-bit library.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft ACE OLEDB 12

Mohamad_Dakkouri — Tue, 25 Jul 2023 19:26:00 GMT

THANK YOU VERY MUUUCH !!!!!!!!!!!!!!!!!!!

it worked with 32 bit

I will put the link here : Download Microsoft Access Database Engine (32-bit) (softsea.com)

Sans virus.www.avast.com