I'm running into a problem when using the VFP ODBC driver from within Active Server Pages to access to VFP table. A huge number of TMP files are being left behind in the \windows\temp folder. Almost certain that it's the VFP ODBC agent that's doing it. I know it definitely happens with VFPODBC.DLL on both a W2K server and a W2003 server, however on a W2003 server I don't see it happening with VFPOLEDB.DLL. (Yes, upgrading all servers out there to VFPOLEDB may solve the problem, but I'm still curious about this).

Would leaving an ADO recordset open before releasing the object reference to the recordset cause this problem, such as doing:
set oRS=nothing ... before doing an oRS.Close
(I thought cleanup here was supposed to be automatic).

Has anybody else had any problems with this and/or found a solution? Thank you.