>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?
Try
TMPFILES=F:\
and check what SYS(2019) and SYS(2023) return when application is run. Maybe it uses another config.fpw.
--sb--