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

Resolved PowerServer error connecting to Oracle: System.Data.OracleClient require 8.1.7 version

  1. Issue
0
Votes
Undo
  1. Alex Hernandez
    Alex Hernandez
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 3 September 2021 09:29 AM UTC

Hello,

We installed a PowerServer 2020 in a server and deployed a mobile application there that connects to an Oracle database. It all worked correctly and our customer could begin to work with it.

But some days later the mobile application began to to throw an error when connecting to the database:
System.Data.OracleClient requiere la version 8.1.7 o posterior del software cliente de Oracle

This server has an Oracle 12 client that connects to the datase correctly. We test the connection with a PowerBuilder 2019R3 that is also installed in this computer and it also works. But if we test the connection in the PowerServer AEM it fails with the same error. It seems that PowerBuilder and PowerServer connect to the Oracle database in different ways, but I don't know what they are.

We have tried to follow some instructions like this one:
https://docs.appeon.com/ps2020/appeon_troubleshooting_guide/oracle_9i_failed_system.html

But it does not solve our problem. Any ideas?

Thank you for you help.

 

 

 

Timeouts occurring in PowerServer web app so Oracl...
IWA update prompt
Responses (6)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 3 September 2021 09:59 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hola,

Maybe the difference is between using a 32 vs 64 bit oracle client?

Just an idea. It would depend if you run it in a 64 or 32 bit browser maybe.

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 3 September 2021 14:04 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Alex;

  FYI: The Mobile App is not connecting to the O12C DB - the PowerServer 2020 middle-ware server is.

  Yes, PB and PS use different mechanisms (clients) to connect to the same Oracle DB instance. The AEM error points to the MS-Windows "Server" where PS2020 is installed and how that environment is connecting to your O12C DBMS. You cannot compare PB & PS connectivity as while similar, they are technically different and as Alex points out - probably 32bit (PB) and 64bit (PS).

  I would recommend focusing on PS2020 and it's corresponding "Data Source" definition and settings as to why this connectivity error is occurring. Maybe even use an external 64bit Oracle Utility like SQL*Plus or a 3rd party program like TOAD to see if your Oracle Client (I like the "Instant Client" driver version personally) is working OK from the PS2020 server's machine over to O12C.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Alex Hernandez
Alex Hernandez Accepted Answer Pending Moderation
  1. Monday, 6 September 2021 07:53 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Hello,

Thank you for your response. In PS2020 server there's an 64bits Oracle client and SQLPlus connects correctly to the database. I've changed the name of the Oracle Client folder (so would not be found as it does not much with the registry information) and the error is the same. So it seems that in fact PS2020 does not find any oracle client installed.

I will continue trying things but I don't know where PS2020 is looking for the oracle client.

Regards,

Alex.

Comment
There are no comments made yet.
Alex Hernandez
Alex Hernandez Accepted Answer Pending Moderation
  1. Monday, 6 September 2021 07:53 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Hello,

Thank you for your response. In PS2020 server there's an 64bits Oracle client and SQLPlus connects correctly to the database. I've changed the name of the Oracle Client folder (so would not be found as it does not much with the registry information) and the error is the same. So it seems that in fact PS2020 does not find any oracle client installed.

I will continue trying things but I don't know where PS2020 is looking for the oracle client.

Regards,

Alex.

Comment
There are no comments made yet.
Alex Hernandez
Alex Hernandez Accepted Answer Pending Moderation
  1. Monday, 6 September 2021 07:54 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 5

Thank you for your response. Could be something about 32/64 bits but I've not found yet the key.

Comment
There are no comments made yet.
Alex Hernandez
Alex Hernandez Accepted Answer Pending Moderation
  1. Wednesday, 8 September 2021 11:37 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 6

Hi,

At least, after reinstalling the Oracle clients I followed again the instructions from this link:

https://docs.appeon.com/ps2020/appeon_troubleshooting_guide/oracle_9i_failed_system.html

And I don't know why this time it worked! So it was a matter of permissions.

 

Regards,

Alex.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 8 September 2021 17:18 PM UTC
Thanks for sharing the solution!
  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.