topic RE: OraOLEDB.Oracle' provider is not registered on the local machine in Product Forum

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

KummariSrikanth — Mon, 22 May 2023 11:52:00 GMT

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

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

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

ewilson — Mon, 22 May 2023 15:28:00 GMT

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

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

KummariSrikanth — Mon, 22 May 2023 17:03:00 GMT

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

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

ewilson — Mon, 22 May 2023 17:14:00 GMT

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

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

KummariSrikanth — Tue, 23 May 2023 05:32:00 GMT

Hi @ewilson

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

Thanks & regards,
Srikanth K

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

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

AtyantSrivastav — Tue, 23 May 2023 12:54:00 GMT

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

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

KummariSrikanth — Wed, 24 May 2023 05:49:00 GMT

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

Regards & Thanks,
Srikanth K

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

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

KummariSrikanth — Thu, 25 May 2023 05:16:00 GMT

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

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

ewilson — Thu, 25 May 2023 14:53:00 GMT

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

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

AtyantSrivastav — Fri, 26 May 2023 04:59:00 GMT

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

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

KummariSrikanth — Fri, 26 May 2023 10:41:00 GMT

Hi,
Sorry,I could not find the Oracle connector in the DX . Please help me.

Thanks & Regards,
Srikanth K

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

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

ewilson — Fri, 26 May 2023 14:08:00 GMT

@Kummari Srikanth

Same link that I posted earlier in this thread:

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

Cheers,

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