cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pdcmagno
Frequent Visitor

Power Automate cannot connect to On-Premise Oracle Database thru gateway

Hi,

 

I am trying to connect to an Oracle Database thru on-premise gateway but it's throwing me the following error.

 

Test connection failed. Details: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' clientRequestId: 39128f0c-9123-c4a5-3b86-9fbc2a2e177e

 

Client's Oracle DB is in 32 bit thus, Oracle Client is in 11g 32 bit. 

 

Are there any other settings I need to do to accomplish this? I also encounter this using Power BI Online.

1 REPLY 1
eric-cheng
Solution Sage
Solution Sage

Hi @pdcmagno ,

 

I haven't connected to an on premise Oracle db before but according to this post here, it requires a x64 Oracle client.  Not sure if there are any workarounds.

 

Thanks 

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,514)