I have a program that uses SQLEXEC to get data from an SQL2000 server. The program is running from foxpro 7 on the same NT box as the SQL2000 server. Unfortunately the server's C:\ drive is full. I handle this by setting TMPFILES F: in the config.fpw so that foxpro uses the f:\ drive instead which has a great deal of open space. This works great with .dbf's.

However when I run an SQLEXEC command that is bringing back a data set it ignores the foxpro setting and stores the cursor file on the c:\ drive in the user's document directory. The program crashes when the resulting cursor becomes too big for the C:\ drive.

Does anyone know how to control the destination for the cursors created from the SQLEXEC command?