title: Deployment Issues: Oracle + EF4 + Win Server 2008
body: <p>I have an ASP.NET Web Forms app that I am building and running against .NET 4.0 on a Win7 local machine. (All is OK on local box.) My app is running EF4.1 against an Oracle DB, so I am using the Oracle EF data provider, which is still in Beta.</p>
  
  <p>Right now, I can successfully deploy the app to my Win2008 Server target machine using Web Deploy from my local VS2010, but when I run the app on the target, I get the classic <code>Unable to find the requested .Net Framework Data Provider</code> error.</p>
  
  <p>Here's my <del>(unsuccessful)</del> setup, as of now:</p>
  
  <ul>
  <li><p>32-bit applications are <strong>enabled</strong> in the app pool (.NET 4.0) on the
  Win2008 Server target.</p></li>
  <li><p><strong>Copy Local</strong> is set to <strong>true</strong> for the <code>Oracle.DataAccess</code> DLL in my local VS2010 solution.</p></li>
  <li><p><em>Both</em> of the <strong>Platform</strong> <em>and</em> <strong>Platform target</strong> settings are set to <strong>Any CPU</strong> in my local Build Configuration. (I have tried
  different settings here without success.)</p></li>
  <li><p>The Win2008 Server target does <strong>not</strong> have an <code>Oracle.DataAccess</code> DLL in
  the GAC. (I thought that setting Copy Local on the Oracle DLL would
  mean that I didn't need the GAC.)</p></li>
  </ul>
  
  <p><strong>EDIT</strong>: I have tried to GAC the <code>Oracle.DataAccess</code> DLL, but I get the same error that is discussed <a href="https://stackoverflow.com/questions/4216606/why-cant-i-install-my-service">here</a>. (I still have to investigate this.) Also, there is already another Oracle client on my target box, and installing the Oracle client that comes with the Oracle EF data provider seems to interfere with it. This cannot be allowed to happen.</p>
  
  <p><strong>Question 1</strong>: What combination of build configuration settings (on the local box) and IIS settings (on the target) do I need to select in order to be able to run my app on the 2008 Server?</p>
  
  <p><strong>Question 2</strong>: How can I get this to work without installing another Oracle client on my target server? </p>
  
  <p>Thanks again for the help.</p>
  
  <p><strong>Update: All is working</strong>. See my answer below for a link to the full solution, as well as links to helpful information. </p>