MicrosoftHi,
After learning about this great new feature Polybase I started to implement it against a Oracle 12c external server.
I have still not had success in getting this to work, even after upgrading my SQL2019 to cu2 (build 15.0.4013.40)
I have both used TSQL and "Azure Data Studio" and the error I get is:
"110045;User authorization failed: [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied Additional error <2>: ErrorMsg: [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied, SqlState: 28000, NativeError: 1017"
This might be fixed by changing sqlnet.ora - "sqlnet.allowed_logon_version_server" but I do not have control over the ORA server.
There seems to have been a similar error fixed in cu2: https://support.microsoft.com/en-us/help/4537072/fix-creating-an-external-table-against-an-oracle-database-in-sql-serve - but this does not help me.
So at last my questions are:
- When will MS have a newer ORA driver in the Polybase subsystem?
