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

Resolved Powerbuilder 2019 R2 Database connection

  1. How-to
0
Votes
Undo
  1. mithu antony
    mithu antony
  2. PowerBuilder
  3. Tuesday, 24 November 2020 16:36 PM UTC

I recently installed Powerbuilder 2019 R2. When trying to connect to Oracle database 12c through database interface I get error

“ORA-01017:invalid username/password;logon denied"

 My user credentials are right and I am able to connect to sql developer using the same credentials

I have tried with below 3 database interfaces

O10 Oracle 10g, O90 Oracle 9i, ORA Oracle. All returns the same error.

 

I have oracle client 11g.

Please help me understand what is missing here.

 

Is it because of any missing DLLs . I only have pbora190.DLL in the 

Shared\PowerBuilder\x64 and Shared\PowerBuilder\ folders

Consume RestAPI with url image
PrintGetPrinter crashing
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 25 November 2020 00:59 AM UTC
  2. PowerBuilder
  3. # 1

Check with your DBA to ensure that your account is not locked.

That's exactly the message you will get when attempting to connect with valid credentials if the account is locked.

 

Olan

Comment
mithu antony
  1. mithu antony
  2. Wednesday, 25 November 2020 01:30 AM UTC
My account is not locked. I am able to connect to this database through sql developer
  1. Helpful
There are no comments made yet.
mithu antony
mithu antony Accepted Answer Pending Moderation
  1. Tuesday, 24 November 2020 18:01 PM UTC
  2. PowerBuilder
  3. # 2

This is the connection string i am using . I have used ORA Oracle

QLCA.DBMS = "ORA Oracle"
SQLCA.LogPass = <**************>
SQLCA.ServerName = "XXX"
SQLCA.LogId = "userid"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PBCatalogOwner='userid'"

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 26 November 2020 17:44 PM UTC
Well you'd probably have to open port 1521 but usually the installation of the oracle client should have taken care of that.

If you can connect with SqlDeveloper, I'm also inclined to think that the port is already correctly configured, unless SqlDeveloper is using a JDBC driver and a different connection profile.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 26 November 2020 17:47 PM UTC
Do you have a TNS_ADMIN or ORACLE_HOME environment variable configured in windows? If so, see if they point to the correct folder where your tnsnames.ora file should be.

If you don't have any of them, try using the TNS_ADMIN environment variable, it has solved many times funny problems for me when a user has had multiple Oracle clients installed and they haven't been uninstalled correclty.

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 26 November 2020 17:53 PM UTC
And then of course ... (this might sound strange), there's this very very weird bug with the tnsnames.ora file. Sometimes there's a funny character somewhere (not visible), especially when you copy an existing profile and then modify the data of it for your new profile.

Try deleting the one you are using and write it manually from scratch. (but only if a TNSPING from the commandline doesn't work !!).

  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 24 November 2020 17:56 PM UTC
  2. PowerBuilder
  3. # 3

Hi,

You could give us a bit more information: Which connection parameters are you using?
(you should use "ORA .. " for the sqlca.dbms when using 11g).

regards

Comment
mithu antony
  1. mithu antony
  2. Tuesday, 24 November 2020 18:08 PM UTC
0

Votes

This is the connection string i am using . I have used ORA Oracle



QLCA.DBMS = "ORA Oracle"

SQLCA.LogPass = <**************>

SQLCA.ServerName = "XXX"

SQLCA.LogId = "userid"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PBCatalogOwner='userid'"
  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.