Microsoft ACE OLEDB 12

[Mohamad_747]

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
------------------------------

[Devendra_KumarP]

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
------------------------------

[ewilson]

@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
------------------------------

[Mohamad_747]

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

[ewilson]

@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
------------------------------

[Mohamad_747]

Hi all,

I have Blue Prism 7.1.

I have used 64 bit.

Any suggestions ?

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

[ewilson · Accepted solution]

@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
------------------------------

[Mohamad_747]

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