cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nithin_Vanam
Helper II
Helper II

Error connecting to Oracle DB

Hello,

 

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:

 

Oracle Error.PNG

 

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.

 

Regards,

Nithin

3 REPLIES 3
pre
Community Support
Community Support

Hello @Nithin_Vanam 

What is the authentication type you have in the list. Change it accordingly .It should work.

 

Thanks

@pre , the only authentication i see is Basic. There are no other options displayed. 

pre
Community Support
Community Support

Hello @Nithin_Vanam 

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::
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-oracledb
https://powerapps.microsoft.com/en-us/blog/connecting-to-oracle-database-from-powerapps-flow-and-log...

Thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,135)