SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Difficulty connecting to oracle database

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Difficulty connecting to oracle database

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.

 

 


erroprotocol.png

Accepted Solutions
Solution
‎06-12-2017 08:57 AM
SAS Super FREQ
Posts: 108

Re: Difficulty connecting to oracle database

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"

View solution in original post


All Replies
Solution
‎06-12-2017 08:57 AM
SAS Super FREQ
Posts: 108

Re: Difficulty connecting to oracle database

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"

Senior User
Posts: 1

Re: Difficulty connecting to oracle database

Posted in reply to RonAgresta
Thank you for the informations. Regards.
New Contributor
Posts: 2

Re: Difficulty connecting to oracle database

Posted in reply to RonAgresta
Thank you for the informations. Regards.
Contributor
Posts: 22

Re: Difficulty connecting to oracle database - Error ORA-28040

Posted in reply to RonAgresta

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

SAS Employee
Posts: 272

Re: Difficulty connecting to oracle database - Error ORA-28040

Posted in reply to LuisLeiteBR

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 634 views
  • 1 like
  • 5 in conversation