1. Ron Calder
  2. PowerBuilder
  3. Wednesday, 28 February 2018 12:00 PM UTC

Trying to connect to an Oracle database that worked on Monday and now does not. The DB is up and running and I can access it as a client server PB APP.  When I check the profile used to deploy to Power Server I get the Failed to connect message.  I can tnsping the db and log in with any other sql tool and all works fine.  Any ides? 

Also see this message. What does it mean....

Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 1 March 2018 15:12 PM UTC
  2. PowerBuilder
  3. # 1

Did corporate change the Oracle Client from 32 bit to 64 bit?

I had this issue recently and returning to the 32 bit version of the Oracle client resolved it for me.

 

Olan

Comment
  1. Ron Calder
  2. Thursday, 1 March 2018 15:39 PM UTC
Hi Olan,



I have the 32bit client and Oracle 64bit Enterprise server running.  and have never had this issue.  I have had the Avecto client change to give me full ADMIN rights and the latest McAfee removed rolled back to the prior version and I'm still having trouble.  PB Client serve app works fine with 32bit oracle client.  Appeon servers can see the Oracle DBs but the configuration for deployment can't see the DBs.  I'm totally confused!  



Thank you,



Ron 

  1. Helpful
There are no comments made yet.
Marco Meoni Accepted Answer Pending Moderation
  1. Wednesday, 28 February 2018 13:14 PM UTC
  2. PowerBuilder
  3. # 2

Hi Ron,
Monday is usually a good day to have things working :D

Just joking. 
Are you running on a 64bit box?
Be aware that the DB Profile configuration in the PB IDE needs 32bit drivers.

Are you running you PB c/s app from the same machine and same native interface? Or maybe in PB you connect via ODBC?

Cheers,
Marco

Comment
  1. Ron Calder
  2. Wednesday, 28 February 2018 15:55 PM UTC
I'm using the 32bit drivers Native Oracel drivers on my 64bit windows 7 machine.  The PB IDE is installed on that machine and it can see the oracle drivers and databases with no problem.  The problem is just with the deployment side of PB 2017 R2 to Power Server.  The configurations for deployment can't see the Oracle DBs. 



I tried switching the Power Server Deployment Profiles to use ODBC but they do not work also.  I have uninstalled and reinstalled PB 2017 R2 and I'm still having the problem.  I'm know thinking that corporate IT locked something down on my PC that PB can no longer call as a sub-process even if I run with Admin privs.



Regards,



Ron



P.S. I get most of my work done on Mondays! LOL

  1. Helpful
  1. Marco Meoni
  2. Wednesday, 28 February 2018 16:48 PM UTC
Hello,



unfortunately the error is not informative at all.



I can easily reproduce the same message trying to connect to AppeonSample SA DB and mistyping the password: "Failed to connect to the database" pops up.



The Oracle error log on your side should probably give a better clue.



Cheers,



Marco

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to 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.