Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mgrobertson1
New Contributor

ERROR 28000 Qlik ODBC Oracle Wire Protocol driver Oracle ORA-01017:invalid username/password; login denied

In an attempt to connect to our database instance using Qlik Sense Desktop, the following error was encountered.Qlik Error 28000.PNG

The user's access credentials (hostname, port, service name, username and password) were verified as correct with the database, and correctly entered in the "Create a connection - Oracle" fields for Qlik Sense Desktop.  Looks as if the error may be internal to the application.  Is there any further remediation steps, or is this a known bug?

Qlik Sense Desktop version is 11.24.1

Qlik Sense Version.PNG

2 Replies
MVP
MVP

Re: ERROR 28000 Qlik ODBC Oracle Wire Protocol driver Oracle ORA-01017:invalid username/password; login denied

Which driver are you using?

2018-01-24 21_00_35-Inbox _ Qlik Community.png

ODBC, OLE DB or the Qlik ODBC Connector Package?

mgrobertson1
New Contributor

Re: ERROR 28000 Qlik ODBC Oracle Wire Protocol driver Oracle ORA-01017:invalid username/password; login denied

Apologies for the delayed response...

I am using the Oracle in OraClient12 ODBC connector. 

I had researched this further with Oracle.  A related issue documented suggests changing the password to upper case.  This actually worked, but makes no sense to me or the DBA.  The Oracle documentation is attached.

Error: "Oracle ODBC Ora ORA-01017: invalid username/password; logon" When Attempting To Create An ODBC Connection To An Oracle P6 EPPM Schema (Doc ID 1581032.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=449422905404641&parent=EXTERNAL_SEAR...

For further information, refer to the following forum:https://forums.oracle.com/thread/2148256

Community Browser