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

Resolved PowerServer 2022 and Oracle 10g

  1. How-to
0
Votes
Undo
  1. Chakrapani Salumuri
    Chakrapani Salumuri
  2. PowerServer
  3. Monday, 31 July 2023 08:19 AM UTC

Hi

We are trying to Configure PowerServer 2022. In Database when we are giving the Oracle 10g Credentials Its not taking. Please suggest alternative to connect to Oracle 10g. ( We know PS2022 supports 12c on words. Migration from 10g to 19c is under process and don't know when it will complete)

Please Suggest an alternative.

Thanks & Regards

Chakrapani

+91 9949247495

Problems with deploying Power Server application
Powerserver - SQL Anywhere 17 Connection cannot be...
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 31 July 2023 08:29 AM UTC
  2. PowerServer
  3. # 1

Hi,

Powerserver requires at least Oracle 12c client. If I remember well, there was still some kind of bug with 12c, which was supposed to be resolved, but never was. I'd recommend using Oracle 19c driver for the client. Not sure how much it's backwards compatible.

regards

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 31 July 2023 14:14 PM UTC
Correct Miguel but not only that - the DBMS server *must* also be O12C or higher.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 31 July 2023 15:04 PM UTC
Thanks I didn't know that. I've been using an 11g Server with Oracle 12c client without problems, but of course: 11g is not 10 ?

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 31 July 2023 15:50 PM UTC
You have to remember that PowerServer does *not* use the Oracle DB client software. Instead, it uses its own native C# drivers. The Oracle C# native driver does not support anything below 11G. ;-)
  1. Helpful 2
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 31 July 2023 09:27 AM UTC
  2. PowerServer
  3. # 2

I just had a look at https://stackoverflow.com/questions/64903256/connecting-to-oracle19c-server-using-oracle11g-client

The oracle 19c client is not backwards compatible for Oracle server 10.

So you'd have to use some 12c client or upgrade your server.

regards.

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 31 July 2023 18:30 PM UTC
  2. PowerServer
  3. # 3

PowerServer 2022 only supports Oracle 12c - 21c: https://docs.appeon.com/ps2022/Database_Server.html  

You must first upgrade your Oracle database before you can use PowerServer 2022.

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.