How to connect to QlikView new database.

[qwebnm]

I'm trying to connect QlikView to a new database, but it doesn't work.

And when I connect to datasource, I get this faile error.

Connection Test Failed
SQL##f - SqlState: S1000, ErrorCode: 28040, ErrorMsg: [Oracle][ODBC][Ora]ORA-28040: No matching authentication protocol

What's the matter?

please tell me how.

Please check the attached image.

[Daniele_Purrone]

Hi @qwebnm : from the screenshots, I cannot see which driver exactly you are trying to use when setting up the connection. Is it the Qlik-oracle one, or the one provided by Oracle?

[qwebnm]

Looking at the DSN, it seems that you are using oracle in oraClient 10g_home1 as the driver.

And when I connect to datasource, I get this faile error.

Connection Test Failed
SQL##f - SqlState: S1000, ErrorCode: 28040, ErrorMsg: [Oracle][ODBC][Ora]ORA-28040: No matching authentication protocol

[Chip_Matejowsky · Accepted solution]

Hi @qwebnm,

The error ErrorCode: 28040, ErrorMsg: [Oracle][ODBC][Ora]ORA-28040: No matching authentication protocol is what QlikView is receiving from the source and is not a QlikView error per se.  Suggest that you discuss this error with your DBA and also check Oracle documentation for error number.  

https://support.oracle.com/knowledge/Oracle%20Database%20Products/1957995_1.html looks to have some information about the error code.

• Description

ORA-28040: No matching authentication protocol

• Cause

There was no acceptable authentication protocol for either client or server.

• Action

The administrator should set the values of the SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters, on both the client and on the server, to values that match the minimum version software supported in the system. This error ORA-28040 is also raised when the client is authenticating to a user account which was created without a verifier suitable for the client software version. In this situation, that account's password must be reset, in order for the required verifier to be generated and allow authentication to proceed successfully.

Best Regards