Foxhound 2.0 FAQ
Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Question: How do I move the SQL Anywhere temporary file for Foxhound to a different physical drive?

Answer:

One method is to set the SATMP environment variable to specify the folder where SQL Anywhere will put all its temporary files:

Control Panel in Windows XP...

  System 
      - Advanced tab 
         - Environment Variables button 
            - System variables 
               - New button
                  - New System Variable dialog box
                    Variable name:  SATMP
                    Variable value: F:\data\SQL_Anywhere_temp

Control Panel in Windows 7... 

   System 
      - Advanced system settings 
         - Advanced tab 
            - Environment Variables button 
               - System variables 
                  - New... button
                     - New System Variable dialog box
                       Variable name:  SATMP
                       Variable value: F:\data\SQL_Anywhere_temp
In a batch file...

   SET SATMP=F:\data\SQL_Anywhere_temp

Another method is to modify the dbsrv12.exe command line which starts Foxhound to include the -dt F:\data\SQL_Anywhere_temp option; this will only affect the temporary file associated with the Foxhound database:

"%SQLANY12%\Bin64\dbspawn.exe"^
  -f^
  "%SQLANY12%\Bin64\dbsrv12.exe"^
  -c 25p^
  -ch 50p^
  -cr-^
  -dt F:\data\SQL_Anywhere_temp^
  -gk all^
  -gn 120^
  -gna 0^
  -n foxhound2^
  -o foxhound2_debug.txt^
  -oe foxhound2_debug_startup.txt^
  -on 1M^
  -qn^
  -sb 0^
  -x tcpip^
  -xd^
  -xs https(identity="%SQLANY12%\Bin64\rsaserver.id";identity_password=test;port=443;maxsize=0;to=600;kto=600)^
  foxhound2.db^
  -n f
Here's the list of Foxhound command files which contain the dbsrv12.exe command:
$backup_foxhound2.bat
$start_foxhound2_chrome.bat
$start_foxhound2_chrome_debug.bat
$start_foxhound2_engine.bat
$start_foxhound2_firefox.bat
$start_foxhound2_firefox_debug.bat
$start_foxhound2_ie.bat
$start_foxhound2_ie_debug.bat

By default, the Foxhound command files are installed in this location on Windows XP:

C:\Documents and Settings\All Users\Application Data\RisingRoad\Foxhound2
and on Vista and Windows 7 it is here:
C:\ProgramData\RisingRoad\Foxhound2


This page was last updated on November 15, 2011. Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com