Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

Like (0) Share

Report

Posted on 13 Jan 2021 16:41:26 by ErickDiaz

156

Hi All,

I'm trying to create a Connection from Power Apps to our on-prem Oracle database but I'm getting the following error:

The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider. inner exception: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider. clientRequestId: 5055ee33-f2c5-4e57-84e6-646670844209

I'm working with the Gateway Server administrator, she was able to replicate the error using Power BI Desktop on this server. We followed Microsoft instructions and downloaded and installed "64-bit ODAC 12.2c Release 1 (12.2.0.1.1) for Windows x64" and configured the tnsnames.ora file. After that, we were able to connect to the Oracle database from Power BI Desktop but the error is still happened when trying to create the connection from Power Apps.

Any ideas?

Thank you,

Erick

Categories:

Connecting to Data

Connectors

Dataflows

All responses (7)

Answers (1)

Damianm22 2 on 15 Jun 2021 at 22:26:01

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

Hi Erik,
Hope you are well.

I am having the same problem.
Do you mind helping me solving it?

Thanks
RC-23071548-0 Microsoft Employee on 15 Jun 2021 at 18:41:26

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

Yes that is the latest. If you want previous version they are here - Previous monthly updates to the on-premises data gateways | Microsoft Docs
FacundoGorla 293 on 15 Jun 2021 at 18:36:57

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

I followed the official links from the beggining and used this one. I suppose this is the one to use right?
RC-23071548-0 Microsoft Employee on 15 Jun 2021 at 16:44:56

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

My issue was resolved too after updating to the latest version of the data gateway software. Thanks
Verified answer

ErickDiaz 156 on 15 Jun 2021 at 15:20:31

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

@FacundoGorla,

My error has been resolved since then. The problem was that we were using an old data gateway version.

Try downloading the latest data gateway version and the error should go away.

Thank you,

Erick
FacundoGorla 293 on 15 Jun 2021 at 15:15:22

Like (1)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

This is not usefull AT ALL. It only says that if you have the error showed above, download the client version. I HAVE INSTALLED that version already but the error keeps showing.

Oracle server 11g
Oracle client 12.2.....

And still can't use Oracle connector either on power automate nor power apps.
RC-23071548-0 Microsoft Employee on 13 Jan 2021 at 20:40:01

Like (0)

Report

Re: Help with 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' Error

Check if this helps - Connecting to Oracle Database from PowerApps, Flow and Logic Apps | Microsoft Power Apps