OraOLEDB.Oracle' provider is not registered on the local machine

[KummariSrikanth]

I am getting this error:OraOLEDB.Oracle' provider is not registered on the local machine. while connecting with  database.

------------------------------
Kummari Srikanth
------------------------------

[ewilson]

@Kummari Srikanth 

How are you attempting to connect to the Oracle instance? What VBO are you using?

Cheers,

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

[KummariSrikanth]

Hi @ewilson 

I tried both OLEDB VBO and Data- SQL Server VBO to connect with database and get data as collection.

Thanks & Regards,
Srikanth K

------------------------------
Kummari Srikanth
------------------------------

[ewilson]

@Kummari Srikanth 

You won't be able to connect to Oracle using the SQL Server VBO. Two completely different database systems. You should be able to use the OLEDB VBO, but you have to have Oracles OLEDB provider installed on the machine you're testing from and you have to reference it in your connection string.

FWIW - There is an Oracle DB VBO available on the DX. You can find it at the following link:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/oracle-mda---utility

Review the user guide and make sure you install the necessary prerequisites if you want to try it.

Cheers,

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

[KummariSrikanth]

Hi @ewilson 

How to install OLEDB Provider on the machine.Please  kindly guide me on this.

Thanks & regards,
Srikanth K

------------------------------
Kummari Srikanth
------------------------------

[AtyantSrivastav]

Download accessdatabaseengine 64 bit open command prompt and run the below query and restart blue prism and try

C:\your_path_where_exe_is_saved \AccessDatabaseEngine.exe /quiet

------------------------------
Atyant Srivastava Deputy General Manager
Deputy General manager
Personal
Asia/Kolkata
------------------------------

[KummariSrikanth]

Hi,
 Please mention the provider name that should be given in the arguments of the Set Connection Action.

Regards & Thanks,
Srikanth K

------------------------------
Kummari Srikanth
------------------------------

[KummariSrikanth]

Hi @Atyant Srivastava 
 

Downloaded accessdatabaseengine 64 bit opened command prompt and runned the below query and restarted blue prism...

C:\your_path_where_exe_is_saved \AccessDatabaseEngine.exe /quiet

Still getting same error :OraOLEDB provider is not registered on the local machine.

Please help me on this issue.

Regards & Thanks,
Srikanth K

------------------------------
Kummari Srikanth
------------------------------

[ewilson]

@Kummari Srikanth 

The Access Database Engine redistributable is for working with Microsoft Access database instances. You mentioned an Oracle error which implies you're trying to connect to an Oracle database. You can use OLEDB for that, but you must have the Oracle OLEDB provider installed and included in your connection string. Alternatively, there is the Oracle connector on the DX which I referenced previously in this thread. If you want to make use of that connector, you need to read the user guide. There's a prerequisites section that points you to the files you need and where they need to go:


Cheers,

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

[AtyantSrivastav]

I agree with Eric, I misinterpreted the question, you need to install Oracle oledb Provider installed and include in your connection string

------------------------------
Atyant Srivastava Deputy General Manager
Deputy General manager
Personal
Asia/Kolkata
------------------------------