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();