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
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'"