Solved: Power Automate cannot connect to On-Premise Oracle...

pdcmagno · ‎07-25-2021

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.

eric-cheng · ‎07-25-2021

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

View solution in original post

eric-cheng · ‎07-25-2021

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