1. frederic roggemans
  2. PowerServer Web
  3. Wednesday, 01 August 2018

Hello ,


I want to test powerserver 2017r3 with an PowerBuilder application/Oracle database.

When i set database type it's ok and it connect

but when i define the transaction object (On AEM :Welcome > Server > Resources > Data Source > ) the connection is KO.

Any idea ?


Config win7 64bits. (Oracle 32 and 64 bit installed)

Frédéric

 

Attachments (2)
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo
 

Suggestion:

1) Add "Appeon_WorkArounds" PBL to your App's library list

2) SubClass the App's main Window and change its type to an MDI Frame to have the App fully appear in the web browser

3) Use the "of_getClientType ( )" method to find out if your running in the native PB or WEB environment

 
4) Change your Open with the main control window as follows:
 
IF Appeon.of_getclienttype () = "WEB" THEN
    Open ("MDI window")
else
    Open ("Normal window")
END IF
 
HTH
Comment
done :-)



very well.



Thank
  1. frederic roggemans
  2. Wednesday, 1 August 2018
Excellent! ;-)
  1. Chris Pollach
  2. Wednesday, 1 August 2018
There are no comments made yet.
  1. Wednesday, 1 August 2018
  2. PowerServer Web
  3. # 1
frederic roggemans Accepted Answer Pending Moderation
0
Votes
Undo
thank you chris,

I am very impressed with the result appeon.

In appendix printscreen appeon client-server and the same to web;

Bravo Appeon
 
Attachments (2)
Comment
There are no comments made yet.
  1. Wednesday, 1 August 2018
  2. PowerServer Web
  3. # 2
frederic roggemans Accepted Answer Pending Moderation
0
Votes
Undo

thank you, I found the solution.
IIS connectionpool was configured with the network service user who does not have rights to oracle directories.

I changed the definition of appeonconnectionpool with an authenticated user.

sorry for my English.

Frédéric

Comment
Excellent news Frédéric .. happy PowerServing! ;-)
  1. Chris Pollach
  2. Wednesday, 1 August 2018
There are no comments made yet.
  1. Wednesday, 1 August 2018
  2. PowerServer Web
  3. # 3
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Frederic;

  Can you try and add the DataSource for your Oracle instance via AEM?

For example:

 

Does that work OK?

 

Regards ... Chris

Comment
There are no comments made yet.
  1. Wednesday, 1 August 2018
  2. PowerServer Web
  3. # 4
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.