OPENQUERY and "Not enough memory for file map."

• richardx

  Ten Centuries

  Points: 1263

  More actions

  November 12, 2004 at 11:28 am

  #161935

  Using SQL Server 2000 SP3a and Windows 2000 2GB RAM and nothing running on the machine but SQL Server.

  This is an error I get when trying to load FoxPro tables:

  OLE DB provider 'MSDASQL' reported an error. The provider ran out of memory.

  [OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Not enough memory for file map.]

  OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandText::Execute returned 0x8007000e:  The provider ran out of memory.].

  This happens with some, but not all, large tables (several hundred thousand rows).

  Once the error occurs all connections are denied until SQL Server is restarted.

  I've tried many things to try and overcome this, but none seem to do the trick. For example,

    load a maximum of 100,000 rows at a time via a WHERE clause in the OPENQUERY statement using RECNO().

    load the records (100,000 at a time) into a global temporary table and then load the target table which has a PRIMARY KEY CONSTRAINT from the temporary table. The temporary table actually receives all the records, but the INSERT still fails, but with a different 'insufficient memory' error.

  I've seen that others (Google) that have experienced this, but I've not seen any solutions.

  Does anyone have any idea on how to make this succeed in all cases?

  Thanks.

   

• November 15, 2004 at 8:00 am

  This was removed by the editor as SPAM