1. Kelly Amott
  2. PowerBuilder
  3. Wednesday, 5 February 2020 22:07 PM

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?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 16:33 PM
  2. PowerBuilder
  3. # 1
1
Votes
Undo

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 Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 09:35 AM
  2. PowerBuilder
  3. # 2
1
Votes
Undo

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 Accepted Answer Pending Moderation
  1. Thursday, 6 February 2020 06:11 AM
  2. PowerBuilder
  3. # 3
1
Votes
Undo

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
If the DB painter is working but your app is not, then it's probably something wrong in your code.
  1. Armeen Mazda @Appeon
  2. Thursday, 6 February 2020 21:13 PM
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. Kelly Amott
  2. Friday, 7 February 2020 22:34 PM
Great, glad to hear that.
  1. Armeen Mazda @Appeon
  2. Friday, 7 February 2020 23:10 PM
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.