title: RAZOR Syntax connect to Oracle
body: <p>I am converting my classic asp oracle connection to RAZOR from</p>
  
  <pre><code>strConnString = "Provider=OraOLEDB.Oracle; " &amp; _
  "Data Source=(DESCRIPTION=(CID=MY_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=somehost.com)
  (PORT=1524)))(CONNECT_DATA=(SID=somesid)(SERVER=DEDICATED)));" &amp; _
  "User Id=myid;Password=mypassword;" 
  </code></pre>
  
  <p>to</p>
  
  <pre><code>var connString = string.Format("USER ID=myid;Password=mypassword;Data Source=(DESCRIPTION = (CID=MY_APP)
  (ADDRESS = (PROTOCOL = TCP)(HOST = somehost.com)(PORT = 1524)) (CONNECT_DATA = (SID=somesid)
  (SERVER = DEDICATED)))");
  var providerName = "Oracle.DataAccess.Client";
  var db = Database.OpenConnectionString(connString, providerName);
  var qry = "select * from sometable" ;
  db.Query(qry);
  </code></pre>
  
  <p>but I get the following error</p>
  
  <p><em>Unable to find the requested .Net Framework Data Provider.  It may not be installed.</em></p>
  
  <p>When I installed the Installed the win64_11gR2_client I checked these</p>
  
  <ul>
  <li>Oracle Database Utilities</li>
  <li>SQL Plus</li>
  <li>Oracle NET</li>
  <li>Oracle Connection Manager</li>
  <li>Oracle ODBC Driver</li>
  <li>Oracle SQL Developer</li>
  <li>Oracle Objects for OLE</li>
  <li>Oracle Provider for OLE DB</li>
  <li>Oracle data Provider for .NET</li>
  <li>Oracle provider for ASP.NET</li>
  </ul>
  
  <p>Am I missing something ?</p>