1. Dale Fuller
  2. PowerServer Web
  3. Tuesday, 09 July 2019

Hi,

Trying to deploy a simple app as a test to PowerServer Web on a remote server via the Toolkit.  The "Database Type Profile Configuration" screen "Test Connection" Fails with the simple message "Failed to connect to the database" using either ODBC or Native (prefered).  The message is useless in determining what part of the connection attempt is failing.  No issues connecting to the database through PB IDE, Command Prompt or any compiled application (x86 or x64).  MacAfee has not quarantined any files like another post discovered.

Suggestions?

Oracle 12c Instant Client (x86 and x64)

PB2019 w/PowerServer Toolkit

Win10

Accepted Answer
Dale Fuller Accepted Answer Pending Moderation
0
Votes
Undo

Bingo!  Figured it out.  The PowerServer Toolkit Database Type Profile Configuration for Oracle Native Interface is dependent on the Oracle 10 driver (pbo10190.dll).   Since we only have 12c databases, I didn't include it in the install.

Did I miss something in the documentation/release notes that indicates this?  I haven't spotted anything yet.  I'm not going to quite call it a bug, but the Toolkit should have a separate Type for 10g since it uses a different driver than 11g/12c.  Or at least inform you of the dependency. 

Comment
There are no comments made yet.
  1. Wednesday, 17 July 2019
  2. PowerServer Web
  3. # Permalink
Dale Fuller Accepted Answer Pending Moderation
0
Votes
Undo

Still scratching my head on this one...

What are the steps the Toolkit is going through to test PS DB profile connection?  Looking for environment variables?  Locations in PATH in wrong order or missing.  Is it trying to read/write/create a file(s) or temp directory somewhere that it doesn't have permissions for?  Assumptions of where to find various files or components?

Thanks

Comment
0

Votes

Hi dale,



Please try another machine and install 32-bit Oracle full client only.



Regards,

ZhaoKai
  1. Zhao Kai
  2. Tuesday, 16 July 2019
There are no comments made yet.
  1. Monday, 15 July 2019
  2. PowerServer Web
  3. # 1
Zhao Kai Accepted Answer Pending Moderation
0
Votes
Undo

Hi dale,

Please try install 32-bit  Oracle full client only.

Regards,
ZhaoKai

Comment
Hi Dale;

Can you post your PS Toolkit connection tab settings as well as PB's DB profile for the same?

Regards ... Chris
  1. Chris Pollach
  2. Thursday, 11 July 2019
Database Type Profile Configuration -

Database Type: Oracle 10g/11g/12c

Database Interface: Native Interface

Syntax: Checkbox is checked.

Outer Join Syntax: ANSI

Native Interface -

Server: PROD

User ID: c##fullerd

Database and Release are N/A



PB Database Profile Setup - Oracle

Connection tab -

Profile Name: PROD

Server: PROD

Login ID: c##fullerd

Connect as: Default

Object Mode and Commit on disconnect are checked.



PROD does exist in tnsnames.ora I also tried using direct connect in the form SERVER:PORT/SID which fails also. But does work in PB There really isn't much to mess up on. I'm going to try to turn on some Oracle Client Tracing to see if it even gets that far.
  1. Dale Fuller
  2. Friday, 12 July 2019
Turned on Tracing in sqlnet.ora (TRACE_LEVEL_CLIENT=USER) and while connecting or just testing a DB Profile in PowerBuilder will produce trace files, testing the connection in the PS Profile Config Tool does not. Leads me to believe that it is failing to find or call the Client software.
  1. Dale Fuller
  2. Friday, 12 July 2019
There are no comments made yet.
  1. Wednesday, 10 July 2019
  2. PowerServer Web
  3. # 2
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Dale;

    You need to configure the DB Connection in the PS Toolkit like in the PB IDE. The toolkit is like the IDE in that it uses a 32 bit DB client. The only reason the toolkit needs this is to verify your App's SQL. So you should be able to connect to Oracle in the same manner as in the IDE's "DB Profile" Painter.

Regards ... Chris

Comment
It Should. But it is not.
  1. Dale Fuller
  2. Tuesday, 9 July 2019
There are no comments made yet.
  1. Tuesday, 9 July 2019
  2. PowerServer Web
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.