1. frederic roggemans
  2. PowerServer Web
  3. Wednesday, 1 August 2018 16:17 PM

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 @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 20:23 PM
  2. PowerServer Web
  3. # 1
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 20:32 PM
Excellent! ;-)
  1. Chris Pollach @Appeon
  2. Wednesday, 1 August 2018 21:01 PM
There are no comments made yet.
frederic roggemans Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 19:56 PM
  2. PowerServer Web
  3. # 2
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.
frederic roggemans Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 19:40 PM
  2. PowerServer Web
  3. # 3
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 @Appeon
  2. Wednesday, 1 August 2018 19:44 PM
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 16:37 PM
  2. PowerServer Web
  3. # 4
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.
  • Page :
  • 1


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