I am trying to retrieve some data from an Oracle DB through Flows and followed the steps mentioned here: https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-log...
I installed a Gateway and got help in installing an Oracle client on the same server where the gateway resides. Now when i create a flow and try to setup the Oracle connection, i get an error as below:
This is the error message:
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: 7F4B5640-CF33-421B-A57A-E39F8E55E3C1
Verified the Oracle client works too. But is there any step i am missing? Would be of great help if someone could share the step by step process if what i followed is not right. Thanks in advance.
Please check if you can log into Oracle POC server seperately , using the username and password which you used to connect here . What other options you see other than Oracle POC , share me the information.
Check these links and make sure the oracle connection is established as expected::
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!