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

Resolved PowerServer with Oracle Database

  1. How-to
0
Votes
Undo
  1. frederic roggemans
    frederic roggemans
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 1 August 2018 16:17 PM UTC

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)
databasetype.PNG databasetype.PNG
adddatasource.PNG adddatasource.PNG
Deployment of PowerServer Web with PB 2017R3
SQL Server Native Test Connection Freezes AEM Cons...
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 16:37 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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.
frederic roggemans
frederic roggemans Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 19:40 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

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
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 1 August 2018 19:44 PM UTC
Excellent news Frédéric .. happy PowerServing! ;-)
  1. Helpful
There are no comments made yet.
frederic roggemans
frederic roggemans Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 19:56 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3
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)
appeon_cs.PNG appeon_cs.PNG
appeon_web.PNG appeon_web.PNG
Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 1 August 2018 20:23 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4
 

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
frederic roggemans
  1. frederic roggemans
  2. Wednesday, 1 August 2018 20:32 PM UTC
done :-)



very well.



Thank
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 1 August 2018 21:01 PM UTC
Excellent! ;-)
  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.