How to Connect MS Access DataBase in Blueprism

[KarthikGanesh]

Hi All,

I tried to connect MS Access DB with Blueprism but it throw an error for your reference I listed the error's below

I tried with Provider ="Microsoft.Jet.OLEDB.4.0" it throw an Error:- Internal : Could not execute code stage because exception thrown by code stage: Unrecognized database format 'C:\ABI Automation\MICS Reporting Automation\Input\MICS_Input.accdb'.

for the Provider="Microsoft.ACE.OLEDB.12.0" it throw an Error:- Internal : Could not execute code stage because exception thrown by code stage: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

for the Provider= "MSDASQL.1"  and Connection String ="Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=MS Access Database;DBQ=C:\ABI AUTOMATION\MICS REPORTING AUTOMATION\INPUT\MICS_Input.accdb;DefaultDir=C:\ABI AUTOMATION\MICS REPORTING AUTOMATION\INPUT;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" it throw an Error;-  Internal : Could not execute code stage because exception thrown by code stage: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Kindly help me with this to resolve the issue.

Thanks in advance.

------------------------------
Karthik Ganesh
------------------------------

[John__Carter]

Hi Karthik - you should speak to your IT to get the Access Database Engine (ACE) installed on the machine. I think the first error you have provided indicates that the older Jet provider does not recognise the newer database file format.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[KarthikGanesh]

Hi,

Thanks for your response.

I have already installed Access Database Engine in our Local machine.

Can you suggest alternate solutions please.

 Regards,

Karthik Ganesh |  IMPACT Training - Business Intelligence Mobile: +91-8220367233 | Phone: +91-44-6740 4000 | Extn: 13051   Website: www.aspiresys.com | Blog: http://blog.aspiresys.com

[John__Carter]

The error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" indicates that ACE is not available on the machine.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[KarthikGanesh]

Hi John,

Thanks for your response

In my system I installed Microsoft Access Database engine showed below.

but it throws the same error

I hope this Microsoft access database engine and ACE are same if not kindly provide me the details how to install ACE.

 Regards,

Karthik Ganesh |  IMPACT Training - Business Intelligence Mobile: +91-8220367233 | Phone: +91-44-6740 4000 | Extn: 13051   Website: www.aspiresys.com | Blog: http://blog.aspiresys.com

[KarthikGanesh]

Hi John,

I checked my control panel Microsoft Access Database Engine(2010 & 2016) both are installed. But I got the same error

And you said " the older Jet provider does not recognise the newer database file format." then what is the newest Jet Provider to recognise the newer database file format?

Regards,
Karthik

------------------------------
Karthik Ganesh
------------------------------

[AndreiBidirliu]

Hi Karthik, i'm using the following to connect. DBpath being the filepath to the db


------------------------------
Andrei Bidirliu
------------------------------

[KarthikGanesh]

Hi Andrei Bidirliu,

Thanks for your reply.

I Can't able to find Data - MS Access VBO in my Blue Prism

Could you please help me to find where it is or guide me how to access that VBO and how to download it.

Thanks in advance.

Regards,
Karthik

------------------------------
Karthik Ganesh
------------------------------

[John__Carter]

Hi Karthik - check this article and look for the 'not registered on the local machine' error online. It could be a 32/64bit issue.


------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[marco.pogliaghi]

Hi, I'm jumping in because I've the same type of issue: I have a " Provider 'Microsoft.ACE.OLEDB.12.0' in not registered...", but trying to access the same database with the same Provider with excel works, and, checking all registered providers in powershell with the command 
        (New-Object system.data.oledb.oledbenumerator).GetElements()
I obtain it (amongst others):
============================================
PS H:\> (New-Object system.data.oledb.oledbenumerator).GetElements()


SOURCES_NAME : SQLOLEDB
SOURCES_PARSENAME : {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}
SOURCES_DESCRIPTION : Microsoft OLE DB Provider for SQL Server
SOURCES_TYPE : 1
SOURCES_ISPARENT : False
SOURCES_CLSID : {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

SOURCES_NAME : MSDataShape
SOURCES_PARSENAME : {3449A1C8-C56C-11D0-AD72-00C04FC29863}
SOURCES_DESCRIPTION : MSDataShape
SOURCES_TYPE : 1
SOURCES_ISPARENT : False
SOURCES_CLSID : {3449A1C8-C56C-11D0-AD72-00C04FC29863}

SOURCES_NAME : Microsoft.ACE.OLEDB.12.0
SOURCES_PARSENAME : {3BE786A0-0366-4F5C-9434-25CF162E475E}
SOURCES_DESCRIPTION : Microsoft Office 12.0 Access Database Engine OLE DB Provider
SOURCES_TYPE : 1
SOURCES_ISPARENT : False
SOURCES_CLSID : {3BE786A0-0366-4F5C-9434-25CF162E475E}

SOU

===================================

So I don't understand why BP is not getting it, any suggestion?
(oh, BP6.4, Windows 10 and Windows 7), 

Thank you,
    marco

------------------------------
Marco Oreste Pogliaghi
------------------------------