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

Resolved PB19 connection to 18c - TNS:no listener

  1. Issue
0
Votes
Undo
  1. Kelly Amott
    Kelly Amott
  2. PowerBuilder
  3. Wednesday, 5 February 2020 22:07 PM UTC

This is almost a verbatim repeat of a question asked a year ago for which I didn't see a conclusive answer.

I finished testing two migrations with Oracle 9 and am now ready to test the applications with Oracle 18c. My understanding is that PB19 supports connections to 18c using the ORA DB profile. I have set up connections to both my databases and in both instances I get the ORA-12541: TNS:no listener error.

I have installed the Oracle 12 32-bit client.

I have verified I can connect to both using SQL Developer.

I have the tnsnames.ora path in my system variables.

My assumption is that Powerbuilder has the appropriate DLL in it's folder and that at the time the application is deployed it would add the DLL to the project folder. Is that correct?

Guidance?

  1. Database Profile
  2. Oracle
  3. PowerBuilder
Different page layouts in Print Preview and PDF
Crete PBL's from TFS source
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 16:33 PM UTC
  2. PowerBuilder
  3. # 1

Hi Kelly;

  FYI: I am using the O18C DBMS via the O18C "Instant" DB Client installed.  Here are the connection parameters that are working for me ....

// Profile O18C_HR
SQLCA.DBMS = "ORA"
SQLCA.LogPass = <******>
SQLCA.ServerName = "STD-Chris"
SQLCA.LogId = "SYSTEM"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Async=1,DBGetTime=5,TrimSpaces=1"

HTH

Regards ... Chris

Comment
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 09:35 AM UTC
  2. PowerBuilder
  3. # 2

Hi Kelly, you are somewhat right.

When you setup the DB connection in PowerBuilder, you assign a driver name.

// Use PowerBuilder's ORA database driver
SQLCA.DBMS = "ORAcle ..."
// Shorthand >>>
SQLCA.DBMS = "ORA"

PowerBuilder has a runtime DLL named PBORA190.dll (PB 2019). 3 first letters in DBMS defines the DLL file to load.

PB docs describe how PB connects to Oracle server via PBORA190.dll. See:

  • PowerBuilder Help
    • Connecting to Your Database
      • Working with Native Database Interfaces
        • Using Oracle

The subsection titled Basic software components for Oracle displays diagram of the files involved.

HTH /Michael

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 06:11 AM UTC
  2. PowerBuilder
  3. # 3

Are you using either 2017 build #1915 or newer or PowerBuilder 2019 build # 2170 or newer?  Older versions/builds are not compatible with Oracle 18c.

Also, why are you using Oracle 12 client with Oracle 18c DB?  I think it is prudent to upgrade the client also.

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 6 February 2020 21:13 PM UTC
If the DB painter is working but your app is not, then it's probably something wrong in your code.
  1. Helpful
Kelly Amott
  1. Kelly Amott
  2. Friday, 7 February 2020 22:34 PM UTC
What I found is that for the DB Profle I had to replace SYSTEM with the actual logon account in order to connect. When I ran the application though I found that the .ini file was enough for it to connect successfully. I think I'm good now. We'll find out once I figure out deployment. On to the new issue.....
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 7 February 2020 23:10 PM UTC
Great, glad to hear that.
  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.