FoxPro OleDbException: File Too Large

Question

I am running a FoxPro OLEDB query with several joins over a fairly large dataset. However despite only asking for "MAX" or "TOP 100" [rows] data, I get the following error:

System.Data.OleDb.OleDbException (0x80004005): File c:\users\appX\appdata\local\temp\4\00004y7t002o.tmp is too large. [LOCAL]

OR

System.Data.OleDb.OleDbException (0x80004005): Error writing to file c:\users\appX\appdata\local\temp\00002nuh0025.tmp. [REMOTE]

(I have tried the query both locally and remotely).

Seemingly the OLEDB query creates/deletes a huge amount of temp files, e.g.

This would suggest my query is simply too large and will require several smaller queries/workarounds.

The question is: is this a known issue? Is there an official workaround? Would the FoxPro ODBC adapter have the same problem?

Answer 1

Basically 2GB is the upper limit for any file that Visual FoxPro has to deal with. None of those temp files are anywhere near that. Does the location they are being created in have enough disk space? Are there user disk quotas in effect?