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

Resolved Oracle "Failed to connect to the database"

  1. Issue
0
Votes
Undo
  1. Dale Fuller
    Dale Fuller
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 9 July 2019 18:02 PM UTC

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

  1. Database
  2. Oracle
  3. PowerServer Toolkit
"Transaction is not connected" error on database c...
Messagebox_Cutoff
Accepted Answer
Dale Fuller
Dale Fuller Accepted Answer Pending Moderation
  1. Wednesday, 17 July 2019 19:06 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

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.
Responses (4)
Dale Fuller
Dale Fuller Accepted Answer Pending Moderation
  1. Monday, 15 July 2019 15:10 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Tuesday, 16 July 2019 00:24 AM UTC
0

Votes

Hi dale,



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



Regards,

ZhaoKai
  1. Helpful
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 July 2019 01:23 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi dale,

Please try install 32-bit  Oracle full client only.

Regards,
ZhaoKai

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 11 July 2019 20:31 PM UTC
Hi Dale;

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

Regards ... Chris
  1. Helpful
Dale Fuller
  1. Dale Fuller
  2. Friday, 12 July 2019 14:54 PM UTC
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. Helpful
Dale Fuller
  1. Dale Fuller
  2. Friday, 12 July 2019 15:49 PM UTC
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. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 9 July 2019 20:48 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

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
Dale Fuller
  1. Dale Fuller
  2. Tuesday, 9 July 2019 21:09 PM UTC
It Should. But it is not.
  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.