odp.net - Oracle.ManagedDataAccess.Client cannot connect using Windows authentication

Question

We are unable to connect to Oracle 19c using Oracle.ManagedDataAccess.Client and windows authentication. Regular .NET 4.0 apps are able to connect but .NET Core apps are not able to connect (both are using managed driver).

Below is the code we're using:

 var connString = @"User ID=/;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=2501))(CONNECT_DATA=(SERVICE_NAME=test)));";
            using (var comm = new OracleCommand("SELECT 'It Works' FROM DUAL", new OracleConnection(connString)))
            {
                comm.Connection.Open();
                return comm.ExecuteScalar().ToString();
            }

sqlnet.ora is setup properly

Answer 1

等待大神答复