title: "Cannot create an instance of OLE DB provider" error as Windows Authentication user
body: <p>I am trying to run openrowset from MS SQL Server on an Oracle server.</p>
  
  <p>When i execute the following command:</p>
  
  <pre><code>select * from
  OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass', 
  'select * from table')
  </code></pre>
  
  <p>the following error occurs</p>
  
  <pre><code>Msg 7302, Level 16, State 1, Line 1
  Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "(null)".
  </code></pre>
  
  <p>Can anyone tell me how I can use openrowset with <code>OraOLEDB.Oracle</code>?</p>
  
  <p>I am using 64 bit version of MS SQL Server and Oracle OLEDB driver.</p>
  
  <h2>Edit</h2>
  
  <p>I have tried this on two machines running <em>Windows 7 x64</em> &amp; <em>Windows Server 2008 x64</em> with <em>MS SQL Server 2008 x64</em>. Both showed the same error message.</p>