Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved PowerServer Project Oracle Database connection configuration

  1. How-to
0
Votes
Undo
  1. Bryant Burnard
    Bryant Burnard
  2. PowerServer
  3. Thursday, 28 October 2021 21:37 PM UTC
I have been using PowerBuilder R3 Build 2703 (19.2.0.2703) and deploying an application to PowerServer (PB Edition) 2020 Build 2703.00 (64 bit). I have tested my 64 bit Oracle and 32 bit Oracle connections from the PB front ends, and the PowerServer resources/data source, all make connections to the Oracle 19 database I have recently down loaded PB 2021 Build 1288, runtime 21.0.0.1288 and have been trying to configure the same Oracle connection in the PowerServer Project object. I downloaded the Oracle .Net driver, installed the Oracle driver and re-booted. I am getting the following error: OracleInternal.Network.AddressResolution when trying to test the connection in the (from the Web API tab) database Configuration area. How does one debug what the error is? I have tried some of the .Net sugguestions from a Google search.
  1. PowerServer
Modify SQL on PowerServer App
PowerServer 2021 Build and Deploy Errors
Accepted Answer
Bryant Burnard
Bryant Burnard Accepted Answer Pending Moderation
  1. Friday, 29 October 2021 21:22 PM UTC
  2. PowerServer
  3. # Permalink

After some playing in my System variables found that the 64 bit clients had to be first in the path, and no ORACLE_HOME variable set in the User Variables. BUT, a TNS_ADMIN variable needed to be added pointing to the tnsnames.ora file in the 64 bit client. The error went away.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 29 October 2021 21:47 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.