cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft ACE OLEDB 12

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
------------------------------
1 BEST ANSWER

Helpful Answers

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

View answer in original post

7 REPLIES 7

Devendra_KumarP
Level 7

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
------------------------------
Devendra Kumar Prajapati RPA Manager Infosys Chandigarh, India

ewilson
Staff
Staff

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

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


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

Hi all,

I have Blue Prism 7.1.

I have used 64 bit.

Any suggestions ?



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

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

THANK YOU VERY MUUUCH !!!!!!!!!!!!!!!!!!!
it worked with 32 bit



Sans virus.www.avast.com