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

Resolved powerserver not connecting

  1. How-to
2
Votes
Undo
  1. Placide Da Silva
    Placide Da Silva
  2. PowerBuilder
  3. Tuesday, 28 August 2018 18:25 PM UTC

Hello,

I have PB 2017 R3 in Windows 10 with Oracle 10g. PowerBuilder connects fine with the database. But powerserver connection is failing. Here some pictures:

 

Please Help.

Thanks.

Driver for MS SQL Server
How to upload pictures using the database blob obj...
Responses (6)
Donald Clayton
Donald Clayton Accepted Answer Pending Moderation
  1. Wednesday, 29 August 2018 20:30 PM UTC
  2. PowerBuilder
  3. # 1

Installed PowerServer toolkit in a different location on both the Windows 10 machine and the server, now the DB connection is successful.  We consider this a bug in the Oracle driver stack.

Comment
There are no comments made yet.
Andres Slachevsky
Andres Slachevsky Accepted Answer Pending Moderation
  1. Wednesday, 29 August 2018 13:36 PM UTC
  2. PowerBuilder
  3. # 2

If you are ussing the Oracle Instant Client i will work on PB but will not work in powerserver

Comment
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 29 August 2018 03:33 AM UTC
  2. PowerBuilder
  3. # 3

Hi Don,

What’s the PowerServer Toolkit installation path? This issue is possibly caused by an Oracle bug: The Oracle client does not support an installation path (For example: PB, Toolkit etc.) that contains the brackets "(" and ")". Please refer to the article below for more details.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ab662d63-6385-4f73-b27f-d526048f601f/connecting-to-oracle-on-64bit-x64-machine

if this is not the case, please only install the 32-bit Oracle client as it might not get recognized by Appeon PowerServer Toolkit if you install both 32-bit Oracle client and 64-bit Oracle client on the same machine.

You may install either PowerServer X64 on the different machine or install 32-bit PowerServer on this machine.

Regards,
ZhaoKai

Comment
There are no comments made yet.
Donald Clayton
Donald Clayton Accepted Answer Pending Moderation
  1. Tuesday, 28 August 2018 23:43 PM UTC
  2. PowerBuilder
  3. # 4

Hi Chris,

Acknowledged as to the 32 vs 64 bitness, and with Oracle, loading both stacks side by side is a challenge. 

Here is a good link for setting up side by side 32 and 64 bit Oracle client stack

https://psadmin.io/2016/05/24/managing-32-bit-and-64-bit-oracle-client/

 At this point we have replicated the issue on two different client systems.  It's strange as:

1. PB connects (32 bit, using both Native Oracle and ODBC)

2. PowerServer connects (64 bit, using both Native Oracle and ODBC)

3. PowerServer Toolkit (which is 32 bit) will not connect either natively or with ODBC.

Argh, thanks in advance.

Don

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 28 August 2018 23:55 PM UTC
Hi Don;

Yes, it's point #1 that seems to be the issue. I'm not sure why the PS Toolkit has the 32 bit issue with Oracle. I don't have mixed DB bitness issues on my systems. However, I use the Oracle "Instant" client vs the full client (not sure if that could be another option).

I would suggest opening a Support Ticket on the PS Toolkit issue if you cannot resolve this connection issue. The only reason the PST needs the DB connection, is to parse the App's SQL.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Placide Da Silva
Placide Da Silva Accepted Answer Pending Moderation
  1. Tuesday, 28 August 2018 20:29 PM UTC
  2. PowerBuilder
  3. # 5

Hello Chris,

Thanks for your response. We have PB in 32 bit and PS in 64 bit. Both connecting fine. But the PowerServer Tool Kit is not connecting at all either in 32 or 64. We even tried the ODBC connection that failed too.

Comment
Placide Da Silva
  1. Placide Da Silva
  2. Tuesday, 28 August 2018 20:34 PM UTC
Let me clarify more my question:

1. The issue is with PowerServer Toolkit, not PowerServer (which is 32 bit)

2. PowerBuilder 2017 R3 can connect with both ODBC and native Oracle 10

3. PowerServer is 64 Bit and connects with native Oracle 64 bit and ODBC 64 bit without issue.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 28 August 2018 20:08 PM UTC
  2. PowerBuilder
  3. # 6

Hi Placide;

   FWIW: Remember that PB is 32 bit and PS is normally 64 bit in nature. So yoully need to install both DB client bitness drivers for PB & PS use.

HTH

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.