Unanswered

Error connecting to Oracle DB

(0) Share

Report

Posted on by Nithin_Vanam

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-logic-apps/

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

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Priyae on at

Like (0)

Report

Hello @Nithin_Vanam

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

Thanks

Was this reply helpful? Yes No
Nithin_Vanam 95 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Priyae on at

Like (0)

Report

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-logic-apps/

Thanks

Was this reply helpful? Yes No