1. ken chen
  2. PowerServer
  3. Friday, 5 November 2021 09:20 AM UTC

Our ORACLE version is not available (currrent is 11g) ,
Is it possible to choose the old appeon version?

Roland Smith Accepted Answer Pending Moderation
  1. Monday, 8 November 2021 13:31 PM UTC
  2. PowerServer
  3. # 1

PowerBuilder doesn't connect directly to the database server, it connects to the client software. You just need to find a version of Oracle Client that is supported by your version of PowerBuilder that is closest to your version of Oracle server.

Comment
There are no comments made yet.
ken chen Accepted Answer Pending Moderation
  1. Monday, 8 November 2021 05:40 AM UTC
  2. PowerServer
  3. # 2

Hello ,
I received a reply on 10/6, 11g is not supported !
I don't know where I got it wrong ?

Comment
  1. Miguel Leeuwe
  2. Monday, 8 November 2021 09:15 AM UTC
Have you tried using a 12c client?
  1. Helpful 1
  1. mike S
  2. Monday, 8 November 2021 13:48 PM UTC
powerServer! I thought you were asking about powerBuilder.



PowerServer 2020 is completely different than PowerServer 2021. It is so different, they really should have came up with a brand new product name for it rather than a simple number change. You can probably get the older version, but it has a lot of other incompatibilities so it isn't a simple redeployment..



IMO, the differences between oracle 11 and 12 are not that great that things should not work. However that does depend on what you are doing and the problem you are getting.



In any case, if appeon does not support Oracle 11 on powerSERVER 2021 than they are not going to be able to do anything for you.



  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 5 November 2021 13:36 PM UTC
  2. PowerServer
  3. # 3

Greetings, Ken - 

At the start of the PB 2021 publication "Connecting to Your Database" for the Oracle native interface, in the section titled "Supported versions for Oracle", the "ORA" interface (SQLCA.DMBS = "ORA") shows that Oracle 11g is supported, so I'm not sure why you say Oracle 11g is not supported.

https://docs.appeon.com/pb2021/connecting_to_your_database/ch03s05.html#XREF_11471_Supported_versions

If I have misunderstood your question or if this information does not answer your question, please provide some additional details, such as:

1. The version/release/build of PB you are using.
2. The DMBS property value your app is using (SQLCA.DBMS = ???)
3. More information about why you believe 11g is not supported.

Best regards, John

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Friday, 5 November 2021 13:28 PM UTC
  2. PowerServer
  3. # 4

Not sure i understand what you are asking.  

oracle 11g is supported in powerbuilder using the ORA interface.  

https://docs.appeon.com/pb2019r3/connecting_to_your_database/ch03s05.html

 

 

are you asking what oracle client is needed?  That is oracle software, not appeon.

 

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 5 November 2021 09:27 AM UTC
  2. PowerServer
  3. # 5

You can try to use an Oracle 12c Client to connect to your 11g Server. I've done that successfully a few years ago, not sure if it still works.

Comment
  1. Miguel Leeuwe
  2. Friday, 5 November 2021 10:11 AM UTC
If you want to use "the old" appeon version, you have to install the old appeon version. Which version is "the old" version?
  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.