1. Munther Khatib
  2. PowerBuilder
  3. Friday, 18 December 2020 01:44 AM UTC

Hi

We have a PB 12.5 legacy application we are migrating to PB 2019.

The application developer left the company and we just keep it running.

The application was deployed into Appeon 6.5 server and users login using their IE browser.

I can access the application using the browser. But when I try to run it using the PB IDE as a client/server
application it gives me an oracle TNS error about not being able to connect to database.

<<<< Unable to connect to internal database 12560. ORA-12560: TNS protocol adapter error. >>>>

I have installed Oracle 32 bit client on the windows 10 machine and all the profiles that were created
under ORA adapter connect successfully. I have also configured the service names in "tnsnames.ora" and listener and database on server are running fine.

Do you know why the connection and login fails and what do i need to do to run it successfully (i.e use a profile)?
Is this normal code design the developer did so it only works with appeon server or something is missing or buggy in the code?

I have attached a sample of the constructor code "pfc_envent" I found i think is used for login.





Thanks,

Attachments (2)
Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 December 2020 02:21 AM UTC
  2. PowerBuilder
  3. # Permalink

PowerServer 6.5 and PowerBuilder client/server use different database connection mechanism.  In PowerServer you set the database connection in the AEM but in PB client/server you set it in DBParm.  

Comment
  1. Munther Khatib
  2. Friday, 18 December 2020 14:33 PM UTC
Thanks for the explanation.



Does this mean that the source code that validates userid/password in the event i sent you is still being used or not?



I will check AEM today to see where those connections might be.



DO you think I should skip testing the application in client/server mode and wait until I deploy it into Powerserver since the current code will not work in PB IDE?



Thanks,
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 18 December 2020 15:38 PM UTC
If it is PowerServer app there is no point to test client/server... they are completely two different implementations.



Also, PowerServer 6.5 is too old. You MUST upgrade to PowerServer 2020 when you upgrade to PowerBuilder 2019.



PowerServer uses the values assigned to the logID and logpass to send to the AEM. Everything else about the database connection is coming from AEM not PowerScript.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 18 December 2020 15:39 PM UTC
You really should consider to hire one of our consulting partners to help you. For example David.
  1. Helpful
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Friday, 18 December 2020 11:32 AM UTC
  2. PowerBuilder
  3. # 1

Hi

As Armeen has said the connect is different in client/server, I would expect your code to be picking up the connection details from either an ini file or registry or hard coded.The fact that te IDE conect ok implies that these parameters are not set.

I'm sure it would be fairly trivial to debug and diagnose your problem. I'd be happy to take a look for you if that would help. Perhaps we can schedule a time to screen share and I can talk you through it.

Cheers

David

Comment
  1. Munther Khatib
  2. Friday, 18 December 2020 14:35 PM UTC
Hi David,



How about today Friday. I can send you a webex invite or if you want to set one up i can show you the code.



I am on EST timezone. Let me know your available times.



Munther
  1. Helpful
  1. David Peace (Powersoft)
  2. Friday, 18 December 2020 16:54 PM UTC
Sorry, not available today, I am available on Monday, we are GMT. ping me an email dvp@powersoft-services.co.uk
  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.