title: what would cause a linked server to return a limited amount of data?
body: <p>We are having an issue with a server that we linked to our sql server 2012 instance.</p>
  
  <p>The server that we linked through an odbc or oledb connection is Pervasive SQL.</p>
  
  <p><strong>Selecting from the linked server this way works as long as the result set is small:</strong></p>
  
  <pre><code>select * from linked_server.database..mytable
  </code></pre>
  
  <p>If the result set is more than around <strong>2mb</strong> (might be slightly more or less) then we get this error:</p>
  
  <pre><code>Msg 7399, Level 16, State 1, Line 1
  The OLE DB provider "MSDASQL" for linked server "KSLAP208" reported an error. The provider reported an unexpected catastrophic failure.
  Msg 7330, Level 16, State 2, Line 1
  Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "KSLAP208".
  </code></pre>
  
  <p>However, the silly thing is that SSMS 2012 for instance displays all the columns that need to be returned and then immediatley errors out.</p>
  
  <p><strong>What would cause SSMS 2012 to produce an error on a result set that is too big? (more than 1-2mb)??</strong></p>
  
  <p>here's what i see in the odbc administrator:</p>
  
  <p><img src="https://i.stack.imgur.com/FgEBH.png" alt="enter image description here"></p>