title: Configuration issue with ASP.Net MVC and Oracle on a Windows 10 Server (64-bit)
body: <p>I have developed an ASP.NET MVC application using Visual Studio 2013 Web Express with a backend database as Oracle 11g.  Everything works fine in development environment, i.e. with MVC App and Db deployed on a single machine.  I am able access and use this web app from a client machine and everything works just fine in development environment.  But when published and deployed on IIS 7 running on Windows 10 server, I am unable to establish the Oracle database connection.  I get an error called "Invalid user or logon failed".</p>
  
  <p>I have installed Oracle Developer Tools for Visual Studio 2013, which is available at following link,</p>
  
  <p><a href="http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownloadvs2013-2756823.html" rel="nofollow">http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownloadvs2013-2756823.html</a></p>
  
  <p>The database driver that I am using is Oracle.ManagedDataAccess.Dll, which is getting deployed on the App server (Windows 10 Server 64-bit).  I am bypassing the TNSNAMES.ORA file by specifying the long descriptor in the connection string.  Interestingly, I am able to access Oracle database on this Windows 10 server using Oracle SQL Developer.</p>
  
  <p>It's to do with some configuration settings/Oracle server security settings or IIS settings, which prevents MVC application to pass thru'.</p>
  
  <p>--Contents from Web.Config file</p>
  
  <pre>
  section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess" />
  </pre>
  
  <pre><code>&lt;add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));User Id=scott;Password=tiger;" /&gt;
  </code></pre>
  
  <p>--Code for OpenConnection() Method in OracleDatabaseHandler looks like this</p>
  
  <pre>
      public class OracleDatabaseHandler
      {
          public OracleConnection objConn;
          private void OpenConnection()
          {
              //Load from App.Config file
              log4net.Config.XmlConfigurator.Configure();
              log4net.ILog logger = log4net.LogManager.GetLogger("Logger");  //Declaring Log4Net
  
              string sConnStr1 = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
  
              logger.Info("sConnString : " + sConnStr1);
  
              objConn = new OracleConnection();
              try
              {
                  objConn.ConnectionString = sConnStr1;
                  objConn.Open();
                  if (objConn.State == ConnectionState.Open)
                  {
                      logger.Info("Connection opened successfully");
                  }
                  else
                  {
                      logger.Info("Unable to open the connection");
                  }
              }
              catch (Exception ex)
              {
                  logger.Error(ex.Message.ToString());
                  throw (ex);
              }
          }
     }
  </pre>
  
  <p>Please help.</p>