Database Administration (MOSC)

MOSC Banner

Question related to Oracle Provider for OLE DB and Oracle Data Provider for .NET / ODP.NET

When I use Oracle Provider for OLE DB:


      String CommandText = "select SYS_CONTEXT('USERENV','OS_USER') from

dual";


       OleDbConnection myConnection = new OleDbConnection(connectString);


       OleDbCommand myCommand = new OleDbCommand(CommandText,

myConnection);


       myConnection.Open();


       OleDbDataReader myReader = myCommand.ExecuteReader();


       while (myReader.Read())


           Response.Write("ID: " + myReader[0].ToString());


       myReader.Close();


       myConnection.Close();


I get ID: 9999999999E (The actual user)

However,

When I use Oracle Data Provider for .NET / ODP.NET:


      String connectStr =

ConfigurationManager.ConnectionStrings["LiveConnectionString"].ConnectionStr

ing;


       String CommandText = "SELECT SYS_CONTEXT('USERENV', 'OS_USER') FROM

DUAL";


       using (OracleConnection myConn = new OracleConnection(connectStr))

       {

           OracleCommand myCmd = new OracleCommand(CommandText, myConn);


           myConn.Open();


           OracleDataReader myReader = myCmd.ExecuteReader();

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center