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

[pdcmagno]

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]

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