title: Linked server not getting rows from Oracle DB
body: <p>We are using SQL Server 2008 R2 Standard and linked servers to get information from other Oracle DB's. The provider for our linked servers is the Oracle Provider for OLE DB.</p>
  
  <p>I have this query that I try to run in SQL Server.</p>
  
  <pre><code> select * from [HPROD]..[GTBUD].GT_BUD_COA_VW
  </code></pre>
  
  <p>Using Oracle SQL Developer I can see that there are 44,859 records in the table. Any ideas why I can't get the data? I should point out that the HPROD linked server, the one I'm having trouble with is running Oracle 11g 64-bit 11.2.0.1.0 Production. Our SQL Server is running on a Server 2008 R2 64 box.</p>
  
  <p>The interesting this is we have another linked server called IRPROD using the same provider as HPROD. IRPROD is running the exact same version of Oracle but we have no problems with it. Everything runs fine. </p>
  
  <p>Also, if I try to use OpenQuery, HPROD still will not show any rows.</p>
  
  <pre><code> select * from Openquery(HPROD,'select * from GTBUD.GT_BUD_COA_VW')
  </code></pre>
  
  <p>I'm at a loss. We need to be able to hit these tables. </p>