How To Set Where .tmp Files Are Created with the VFP ODBC Driver (259942)


The information in this article applies to:

  • Microsoft ODBC Driver for Visual FoxPro (Build 6.00.8281.00) 6.0
  • Microsoft ODBC Driver for Visual FoxPro 1.0
  • Microsoft ODBC Driver for Visual FoxPro 2.0
  • Microsoft ODBC Driver for Visual FoxPro 3.0
  • Microsoft ODBC Driver for Visual FoxPro 4.0
  • Microsoft ODBC Driver for Visual FoxPro 5.0
This article was previously published under Q259942

SUMMARY

By default, when Visual FoxPro tables that are accessed by using the Visual FoxPro ODBC driver from a Web page, files with the .tmp extension are created in the Microsoft Windows NT System32 or the Microsoft Windows 9x System sub-directory on the server. This is usually not the desired directory for these files. In order to control this behavior, the System temp environment variable needs to be set on the Server computer.

MORE INFORMATION

To set the System temp environment variable, do the following:
  1. On your computer desktop, right-click on My Computer.
  2. Choose Properties and select the Environment tab.
  3. Click an entry in the System Variables list box (the one on top).
  4. In the Variable and Value Edit control, type the following: Variable = TEMP
    Value = C:\Temp

  5. Click the Set button, and note that TEMP has been added to the list of system variables. Repeat the process for the TMP variable.
  6. Log off and restart the computer.

REFERENCES

For additional information about using Visual FoxPro through the Internet, click the article numbers below to view the articles in the Microsoft Knowledge Base:

165492 How To Use ADO with a Visual FoxPro Database

168053 How To Use VFP Automation Servers with Active Server Pages

150073 How to Query FoxPro Data on the Web Using ODBC

165775 How To Set up a Visual FoxPro Internet Server

Modification Type:MinorLast Reviewed:8/30/2004
Keywords:kbhowto KB259942
©2004 Microsoft Corporation. All rights reserved.