title: SQL Server Linked Server query running out of memory
body: <p>I have a DBF file on a network share that I'm trying to select into a SQL Server table.</p>
  
  <p>This query:</p>
  
  <pre><code>SELECT * FROM OPENQUERY(MyLinkedServer, 'SELECT * FROM DP')
  </code></pre>
  
  <p>... throws this error:</p>
  
  <p>OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[Microsoft][ODBC Visual FoxPro Driver]Not enough memory for file map.".<br>
  Msg 7399, Level 16, State 1, Line 11
  The OLE DB provider "MSDASQL" for linked server "MyLinkedServer" reported an error. The provider ran out of memory.<br>
  Msg 7320, Level 16, State 2, Line 11
  Cannot execute the query "SELECT * FROM DP" against OLE DB provider "MSDASQL" for linked server "MyLinkedServer".</p>
  
  <p>I've read about using SYS(3050) to release FoxPro's memory. I can't figure out how to execute that against the linked server though.</p>