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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,419)