Difficulty connecting to oracle database

[Reifa28]

Hi.

When we try connect to an ORACLE database via DATA MANAGEMENT STUDIO, the error "[DATAFLUX][ODBC Wire Protocol driver]ORA-28040: No matching authentication protocol" is displayed.

What will happen?

Thanks.

[RonAgresta · Accepted solution]

I can't explain why your getting that error but a quick search of our technical support tracks suggested the following possible resolutions:

1. Add the following lines to sqlnet.ora file on the server:

• SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
• SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
• Then restart Oracle TNS Listener

or

2. Use "DataFlux Oracle Driver" instead of the "DataFlux Oracle Wire Protocol Driver"

[LuisLeite]

Thank you for the informations. Regards.

[Reifa28]

Thank you for the informations. Regards.

[LuisLeiteBR]

Mr. @RonAgresta,

Could you, please, explain how to configure this "Dataflux Oracle Driver" in a linux 64 environment?

Wich parameters to use?

Best Regards,

Luis Leite

[JBailey]

Hi @LuisLeiteBR

I am not sure that I understand what you are asking. If you don't mind, can  you post a new question to this forum because this one has been marked as answered. Feel free to mention my name in it so that I see it. 

Best wishes,

Jeff