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: 97

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: 97

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.
☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 254 views
  • 1 like
  • 3 in conversation