Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com     


How?

How do I do a quick reinstall and reactivation of Foxhound?
How do I figure out what went wrong during an installation?
How do I find my OFSS samples?
How do I find the post_setup_trace.txt file?
How do I get a copy of Foxhound?
How do I get a registration key for Foxhound?
How do I get an activation key for Foxhound?
How do I get an HTTP request log for Foxhound?
How do I get the new value of the FOXHOUND5 environment variable to show up after Foxhound is installed?
How do I install a new version of Foxhound?
How do I install Foxhound?
How do I install version 17 of SQL Anywhere on the same machine used to run an earlier version of SQL Anywhere?
How do I make Foxhound web pages available on the internet?
How do I make the post-setup process run faster when a large Foxhound database is being upgraded?
How do I move an existing Foxhound installation to a different location?
How do I move Foxhound to a different disk drive?
How do I move the Foxhound database to a different location?
How do I move the Foxhound transaction log to a different physical disk drive?
How do I move the SQL Anywhere temporary file for Foxhound to a different physical drive?
How do I protect the security of my target database?
How do I quickly shrink the Foxhound database?
How do I read the Foxhound exception messages?
How do I reinstall an earlier build of Foxhound?
How do I reinstall Foxhound?
How do I relocate the Foxhound database from the default installation location?
How do I remove Foxhound from my system?
How do I rename a connection string on the String tab of the Foxhound Menu page?
How do I renew the Rental Edition of Foxhound 5?
How do I report unexpected errors and exceptions?
How do I reset my Foxhound database to empty, without reinstalling?
How do I restore the old build of Foxhound after installing a new build?
How do I run the Foxhound "unsetup" process?
How do I "Save As" an existing connection string to a new string with a different name on the String tab of the Foxhound Menu page?
How do I see Foxhound diagnostics, errors and exceptions?
How do I shrink the size of the Foxhound database?
How do I specify the HTTPS transport-layer security for Foxhound?
How do I stop the "User Id:" and "Password:" from being redisplayed on the Foxhound Menu page?
How do I tell Foxhound to use an HTTP port other than 80?
How do I uninstall Foxhound?
How do I "unsetup" Foxhound?
How do I upgrade Foxhound from one edition to another?
How do I upgrade from the Basic Edition of Foxhound 5 to the Extended Edition?
How do I upgrade from the Rental Edition of Foxhound 5 to the Basic Edition?
How do I upgrade from the Rental Edition of Foxhound 5 to the Extended Edition?
How do I upgrade to a new version of Foxhound without losing any of my data?
How do I upgrade to Foxhound 5?
How many target databases can one copy of Foxhound monitor?
How much disk space does Foxhound need?
How much overhead does the Foxhound connection add to the target database?
rroad_OFSS_load rejected ...

[ Top ]
Question: How do I figure out what went wrong during an installation?
Question: How do I find the post_setup_trace.txt file?

Answer: If the problem occurred during the post-setup part of the Foxhound installation, a complete record of everything that happened may be found in the following files:

$$BUILD_NUMBER.txt
$$FOXHOUND5UPGRADE.txt
$post_setup.bat            
diagnostic_01.txt
diagnostic_02.txt
diagnostic_03.txt
diagnostic_04.txt
diagnostic_05.txt
find1.txt
find2.txt
old_foxhound1_debug.txt
old_foxhound1_debug_startup.txt
post_setup_trace.txt
which are located here on Windows 10:
C:\ProgramData\RisingRoad\Foxhound5\setup\post_setup_trace.txt

If you need help, zip them up and send them to Breck.Carter@gmail.com.

See also...
How do I see Foxhound diagnostics, errors and exceptions?


[ Top ]
Question: How do I find my OFSS samples?
Question: rroad_OFSS_load rejected ...
Question: What happened to my OFSS samples?

Answer: If you don't see your OFSS samples in the Foxhound Sample History page, the OFSS batch files may have been rejected.

To see the reason(s) why, look for messages in the Diagnostics section of the Foxhound Options page.

Here is an example of 4 diagnostic messages in reverse timestamp order, showing one "The error was detected" message followed by 3 "The file is now located here" messages:

 13 - 2018-12-07 16:14:43.950 Full Build 5185a 54 OFSS1400-c4 rroad_OFSS_load moved a leftover file to the rejected subfolder.
   The file is now located here: "C:\DATA\OFSS\rejected\OFSS-inventory17-batch------1c-conn-96c42d62-7447-4453-ab6f-ec0fbdf1c61e.txt"
 12 - 2018-12-07 16:14:43.949 Full Build 5185a 54 OFSS1400-c4 rroad_OFSS_load moved a leftover file to the rejected subfolder.
   The file is now located here: "C:\DATA\OFSS\rejected\OFSS-inventory17-batch------1b-data-96c42d62-7447-4453-ab6f-ec0fbdf1c61e.txt"
 11 - 2018-12-07 16:14:43.947 Full Build 5185a 54 OFSS1400-c4 rroad_OFSS_load moved a leftover file to the rejected subfolder.
   The file is now located here: "C:\DATA\OFSS\rejected\OFSS-inventory17-batch------1a-head-96c42d62-7447-4453-ab6f-ec0fbdf1c61e.txt"

When OFSS batch files are rejected, they are moved to the "rejected" subfolder. For example, if you called rroad_OFSS_load() like this

...
     FROM rroad_OFSS_load ( 'C:\\DATA\\OFSS\\' );
...

then your files may have been moved to this location

C:\DATA\OFSS\rejected


[ Top ]
Question: How do I get a copy of Foxhound?
Question: How do I get a registration key for Foxhound?
Question: How do I get an activation key for Foxhound?

Answer: Foxhound comes in two parts: An Installshield setup file and a registration key.

The setup file can be downloaded from the Foxhound home page.

A registration or activation key for a new copy of Foxhound 5 can be purchased as follows:
30-day Rental Key $99.95 Buy Now What is a "30-day Rental Key"?

New Basic Key $395.00 Buy Now What is a "New Basic Key"?

New Extended Key $495.00 Buy Now What is a "New Extended Key"?

What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
If you are upgrading from Foxhound 3 or 4 you can upgrade for a reduced price:
Basic Upgrade Key $295.00 Buy Now What is a "Basic Upgrade Key"?

Extended Upgrade Key $395.00 Buy Now What is an "Extended Upgrade Key"?
If you already have the Basic Edition of Foxhound Version 5 installed, you can purchase an upgrade key:
Basic To Extended Key $100.00 Buy Now What is a "Basic To Extended Key"?

For more information about editions, see What are the differences among the different editions of Foxhound: Rental, Basic and Extended?

For more information about activation keys, see What are the differences among all the activation keys?


It is also possible to obtain Foxhound via Purchase Order and Invoice; contact Breck.Carter@gmail.com.


See also...
How do I install Foxhound?
How do I reinstall Foxhound?
How do I upgrade Foxhound from one edition to another?
What are the Foxhound system requirements?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?
What happens when a copy of Foxhound expires?
What is a "30-day Rental Key"?
What is a "New Basic Key"?
What is a "New Extended Key"?
What is a "Basic Upgrade Key"?
What is an "Extended Upgrade Key"?
What is a "Basic To Extended Key"?


[ Top ]
Question: How do I get an HTTP request log for Foxhound?

Answer:

At the very least, you must add both the dbn=f and the log=filespec network protocol parameters to the dbsrv17 -xs http(...) parameter when starting Foxhound.

Don't forget the dbn=f parameter; it's not documented as being required, but if you leave it out nothing will be written to the log file.

Also, if you include the lf= network protocol parameter with embedded spaces, the whole http() parameter must be enclosed in double quotes: dbsrv17 -xs "http(...)"

Here is an excerpt from the C:\ProgramData\RisingRoad\Foxhound5\$start_foxhound5_engine.bat command file showing a modified -xs http(...) parameter:

"!SQLANY17!\!BIN!\dbspawn.exe"^
  -f "!SQLANY17!\!BIN!\dbsrv17.exe"^
  -c 25p^
  -ch 50p^
  -cr-^
  -gk all^
  -gl all^
  -gn 220^
  -gna 0^
  -m^
  -n foxhound5^
  -o foxhound5_debug.txt^
  -oe foxhound5_debug_startup.txt^
  -on 1M^
  -qn^
  -sb 0^
  -ufd restart^
  -x tcpip^
  -xd^
  -xs http(port=80;maxsize=0;to=600;kto=600;lopt=ALL,HEADERS;lf="@T - @I - @U - @R - @L - @W - @E";lsize=1M;log=foxhound5_http_log.txt)^
  foxhound5.db^
  -n f

Here's what the resulting output file C:\temp\foxhound_http_log.txt looks like:

11/13 15:18:23.771 - ::1 - / - 200 OK - 597 - 1.143 - 
11/13 15:18:23.845 - ::1 - /rroad_help_frame?f=foxhound_menu - 200 OK - 18319 - 0.065 - 
11/13 15:18:23.882 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.010 - 
11/13 15:18:26.483 - ::1 - /rroad_menu - 200 OK - 43596 - 2.706 - 
11/13 15:18:26.498 - ::1 - /rroad_display_image?f=foxhound_100_75_feathered.JPG - 200 OK - 3027 - 0.001 - 
11/13 15:18:26.499 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.000 - 
11/13 15:18:28.195 - ::1 - /rroad_menu?zt=3&sf1=Automatic%20Refresh&z1=49751546-ba06-472d-84c1-7ec195de3ee2 - 200 OK - 43616 - 0.166 - 
11/13 15:18:28.209 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.000 - 
11/13 15:18:28.209 - ::1 - /rroad_display_image?f=foxhound_100_75_feathered.JPG - 200 OK - 3027 - 0.001 - 
11/13 15:18:29.399 - ::1 - /foxhound?t=rroad_monitor_database3&zi=4 - 200 OK - 618 - 0.010 - 
11/13 15:18:29.456 - ::1 - /rroad_help_frame?f=foxhound_monitor - 200 OK - 73640 - 0.025 - 
11/13 15:18:29.485 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.001 - 
11/13 15:18:36.627 - ::1 - /rroad_monitor_database3?zi=4 - 200 OK - 40843 - 7.197 - 
11/13 15:18:36.671 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.001 - 
11/13 15:18:38.449 - ::1 - /rroad_menu?zt=3&sf1=Automatic%20Refresh&z1=49751546-ba06-472d-84c1-7ec195de3ee2 - 200 OK - 43418 - 0.217 - 
11/13 15:18:38.464 - ::1 - /rroad_display_image?f=foxhound_100_75_feathered.JPG - 200 OK - 3027 - 0.001 - 
11/13 15:18:38.470 - ::1 - /rroad_display_image?f=help.gif - 200 OK - 1261 - 0.001 - 


[ Top ]
Question: How do I install a new version of Foxhound?
Question: How do I upgrade to a new version of Foxhound without losing any of my data?
Question: How do I upgrade to Foxhound 5?

Answer: Here's how to install Foxhound 5 without losing any of your data stored in Foxhound 3 or 4:

  1. Run the new Installshield setup you have downloaded (see How do I install Foxhound?).

  2. The post-setup process will ask how much data you want to preserve; just press Enter for ALL data:
    Post-Setup Process for Foxhound Version 5.0
    *** Checking for a post-setup path parameter...
    *** A post-setup path parameter was provided...
    C:\ProgramData\RisingRoad\Foxhound5\
    *******************************************************************
    ***                   Foxhound 5.0.xxxx
    ***
    *** Here's where Foxhound is being installed:
    *** C:\ProgramData\RisingRoad\Foxhound5\
    ***
    *** Starting the Foxhound 5,0.xxxx post-setup process...
    *** Creating foxhound5.db.5,0.xxxx.ORIGINAL_COPY...
    *** Checking for an existing Foxhound5 installation...
    ***  ...yes, there is an existing Foxhound5 installation.
    *** Checking if the existing data should be upgraded...
    ***  ...yes, the existing Foxhound5 data should be upgraded.
    ******************************************************************
    *** PLEASE READ THIS, AND CONFIRM OR CHANGE **********************
    ******************************************************************
    ***
    *** "FOXHOUND5UPGRADE" specifies how much data is to be upgraded.
    ***
    *** If you want to CHANGE the setting, type in a new value...
    ***    ALL       - upgrade all the data
    ***    OPTIONS   - no samples, just the Foxhound options
    ***    yyyymmdd  - options plus samples since yyyymmdd
    ***    nnn       - options plus last nnn days of samples
    ***    NOTHING   - don't upgrade any data
    *** and press Enter to continue.
    ***
    *** If you LIKE the current setting...
    ***    FOXHOUND5UPGRADE=ALL which means upgrade all the data
    *** just press Enter.
    ******************************************************************
    Current FOXHOUND5UPGRADE=ALL
    New     FOXHOUND5UPGRADE=
    

    For more information about how FOXHOUND5UPGRADE works see Foxhound Help - FOXHOUND5UPGRADE.

  3. When you restart Foxhound you will be asked provide a registration key.


Caution: If you are running Foxhound as a service, stop the service before installing the new version. The installation process needs to stop and restart the existing Foxhound database, and it probably won't be able to do that if it's already running as a service.

Caution: If you are using the Windows Vista or Windows 10 Task Scheduler to take regular backups of your Foxhound database using the $backup_foxhound5.bat file you should reboot your computer after installing a new version of Foxhound.


See also...
How do I install Foxhound?
How do I reinstall Foxhound?
Another version of this product is already installed.
Why is it called "unsetup" instead of "uninstall"?
How do I remove Foxhound from my system?


[ Top ]
Question: How do I install Foxhound?

Answer:

Step 1: Download the Foxhound Installshield setup file from the Foxhound home page.

Step 2: Run setup file; here's what you should see:

Step 1

If you see either of these dialog boxes instead, it means you already have a copy of Foxhound 5 installed:
Another version already installed

Modify, repair, or remove

In the first case, you can run the Foxhound "unsetup" process before doing Step 2 again (run the Installshield setup file).

In the second case, neither Modify nor Repair will work (they won't hurt, but they won't help either)... however, you can use Remove and then do Step 2 again (run the Installshield setup file).

The unsetup and Remove processes will not delete your existing Foxhound database.

See also...
Another version of this product is already installed.
Why is it called "unsetup" instead of "uninstall"?

Step 3: Let the InstallShield process do it's thing:

Step 2
Step 3
Step 4
Step 5
Step 6

Step 4: In the case of a fresh installation the "post-setup" process runs automatically:

Step 8

Step 5: When the setup is finished, press OK to start the Foxhound:

Step9

Step 6: The Foxhound Activation page will appear in the browser window:

Step 10
Step 11
Step 12

See also...
How do I get a copy of Foxhound?
What are the Foxhound system requirements?
How do I install a new version of Foxhound?
How do I reinstall Foxhound?
Another version of this product is already installed.
Why is it called "unsetup" instead of "uninstall"?
How do I remove Foxhound from my system?


[ Top ]
Question: How do I install version 17 of SQL Anywhere on the same machine used to run an earlier version of SQL Anywhere?

Answer: Follow the normal process for installing SQL Anywhere 17; version 17 of SQL Anywhere can coexist on the same computer as all other versions from 6 and up.

There is one caveat, however: The SQL Anywhere 17 installation modifies the Windows PATH environment variable. If you have been relying on the PATH to determine where SQL Anywhere utilities such as dbbackup.exe and dbvalid.exe are located, your Windows command lines and batch files may start executing the version 17 copies of those utilities instead of the version you want. Either change the PATH variable, or modify your Windows command lines to explicitly specify the folder containing the utilities.

Each version of SQL Anywhere comes with its own environment variable that makes it easier to code commands; here's an example of how to use the SQLANY10 environment variable to execute the version 10 copy of dbvalid.exe:

   "%SQLANY10%\win32\dbvalid.exe" -c "ENG=ddd10;DBN=ddd10;UID=dba;PWD=sql" -d -o dbvalid_log_ddd10.txt

Here's a list of the environment variables for each version:

  • Version 6: ASANY

  • Version 7: ASANY7

  • Version 8: ASANY8

  • Version 9: ASANY9

  • Version 10: SQLANY10

  • Version 11: SQLANY11

  • Version 12: SQLANY12

  • Version 16: SQLANY16

  • Version 17: SQLANY17

See also...
What are the Foxhound system requirements?


[ Top ]
Question: How do I make Foxhound web pages available on the internet?

Answer:

By default the built-in Foxhound web server is internet-ready so if the computer running Foxhound is visible on the internet then so are the Foxhound web pages.

For example, if the Foxhound engine is started on a computer with IP address aaa.bbb.ccc.ddd, you can display the Foxhound pages on another computer by specifying the following URL in a browser:

http://aaa.bbb.ccc.ddd/


[ Top ]
Question: How do I make the post-setup process run faster when a large Foxhound database is being upgraded?

Answer:

Try using the SATMP environment variable to put the SQL Anywhere temporary file on a different physical disk drive.


[ Top ]
Question: How do I move Foxhound to a different disk drive?
Question: How do I move an existing Foxhound installation to a different location?
Question: How do I relocate the Foxhound database from the default installation location?

Answer: This example shows how to move an existing Foxhound installation from C:\ProgramData\RisingRoad\Foxhound5 to H:\FOXHOUND5.

  1. Run the Foxhound "unsetup" process: Start - Foxhound5 - 15. Unsetup Fochound

    This step is necessary to remove the Foxhound Windows environment variables, startup shortcuts and some support files, but it won't delete your current Foxhound folder or database file.

  2. Start the Foxhound 5 setup.exe; e.g., Foxhound-Version-5-0-5259-setup.exe

    Note that you do not need your activation key, but you do need stop at the next step:

  3. Stop when the Destination Folder dialog box appears.

  4. Click Change... to open this dialog box: Change Current Destination Folder (NOT RECOMMENDED)

  5. Change the value in the Folder name: field:

    H:\FOXHOUND5
    

  6. Click OK, then Next >

  7. Proceed with the installation until this prompt appears:

    Current FOXHOUND5UPGRADE=ALL
    New     FOXHOUND5UPGRADE=
    

  8. Type the value NOTHING and press Enter.

  9. Press Enter again when this prompt appears:

    Current FOXHOUND5UPGRADE=NOTHING
    New     FOXHOUND5UPGRADE=
    

  10. Proceed with the installation until this page appears in your browser: Activate Foxhound with a Registration Key

  11. Disregard and close the Activation page.

    Note that you don't need to activate this new copy of Foxhound because you'll be copying your old Foxhound database and that's already been activated.

  12. Shut down Foxhound.

  13. Copy (or move) and overwrite these two files:

    From: C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db
      To: C:\FOXHOUND5\foxhound5.db
    
    From: C:\ProgramData\RisingRoad\Foxhound5\foxhound5.log
      To: C:\FOXHOUND5\foxhound5.log
    

    Note that you do not have to run the dblog utility to update the new location of the foxhound5.log file.

  14. Start Foxhound.

  15. Open the Foxhound About page, and verify the location:

    Foxhound database folder: H:\FOXHOUND5
    

  16. Delete the old folder C:\ProgramData\RisingRoad\Foxhound5

See also...
How do I move the Foxhound database to a different location?
How do I move the Foxhound transaction log to a different physical disk drive?


[ Top ]
Question: How do I move the Foxhound database to a different location?

Answer:

Some customers require that software may be installed on the C: drive, for example, but updatable files (e.g., the Foxhound database) must be installed in a different location.

Here is an example that shows how the Foxhound database may be moved from the original installation folder

C:\ProgramData\RisingRoad\Foxhound5

to a different drive

H:\ProgramData\RisingRoad\Foxhound5
  1. Shut down Foxhound if it is running.

  2. Create the destination folder; e.g., H:\ProgramData\RisingRoad\Foxhound5

  3. Move these files from the original installation folder to the new destination:
    foxhound5.db
    foxhound5.log
    rroad5_sa17_bin32.dll
    rroad5_sa17_bin64.dll
    

  4. Create the destination "setup" subfolder; e.g., H:\ProgramData\RisingRoad\Foxhound5\setup

  5. Copy these files from the original "setup" subfolder to the destination "setup" subfolder:
    $$BUILD_NUMBER.txt
    foxhound5.db.5.0.*.ORIGINAL_COPY
    

  6. If it exists, move this subfolder:
    C:\ProgramData\RisingRoad\Foxhound5\backup
    

    to the new destination:

    H:\ProgramData\RisingRoad\Foxhound5\backup
    

  7.   Add or change the code shown in yellow  in these command files:

    C:\ProgramData\RisingRoad\Foxhound5\     $backup_foxhound5.bat

    ECHO OFF
    ECHO Foxhound5 - 3 Backup Database
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     $mini_restore_foxhound5.bat

    ECHO OFF
    ECHO Foxhound5 - 9 Mini-Restore
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    

    C:\ProgramData\RisingRoad\Foxhound5\     $start_foxhound5_default_browser.bat

    ECHO OFF
    ECHO Foxhound5 - 1 Start Foxhound
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     $start_foxhound5_default_browser_debug.bat

    ECHO Foxhound5 - 6 Debug Start Foxhound
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    REM This "debug" version is different:
    REM - There is no ECHO OFF command,
    REM - dbstop runs before dbsrv,
    REM - the dbsrv -qn option is used, and
    REM - there is a PAUSE at the end.
    
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\     start_foxhound5_engine.bat

    ECHO OFF
    ECHO Foxhound5 - 7 Start Foxhound Engine
    REM Optional parameters DBFOLDER SERVER
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\scripts\     $create_SQL_Anywhere_17_bin64_service.bat

    ...
    ECHO To create the Foxhound5 service...
    PAUSE
    "C:\Program Files\SQL Anywhere 17\Bin64\dbsvc.exe"^
      -o "C:\ProgramData\RisingRoad\Foxhound5\dbsvc_log.txt"^
      -y^
      -as^
      -s Automatic^
      -sn Foxhound5^
      -sd "Foxhound Version 5 Database Monitor Bin64 Service"^
      -t Network^
      -w Foxhound5 "C:\Program Files\SQL Anywhere 17\Bin64\dbsrv17.exe"^
      -c 25p^
      -ch 50p^
      -cr-^
      -gk all^
      -gl all^
      -gn 220^
      -gna 0^
      -m^
      -n foxhound5^
      -o "C:\ProgramData\RisingRoad\Foxhound5\foxhound5_debug.txt"^
      -oe "C:\ProgramData\RisingRoad\Foxhound5\foxhound5_debug_startup.txt"^
      -on 1M^
      -qn^
      -sb 0^
      -ufd restart^
      -x tcpip^
      -xd^
      -xs http(port=80;maxsize=0;to=600;kto=600)^
      "H:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"^
      -n f
    ...
    

    C:\ProgramData\RisingRoad\Foxhound5\scripts\     $run_most_recent_mini_restore.bat

    ECHO OFF
    ECHO Foxhound5 - Run Most Recent Mini-Restore
    CD /D H:\ProgramData\RisingRoad\Foxhound5
    SETLOCAL ENABLEDELAYEDEXPANSION
    SETLOCAL ENABLEEXTENSIONS
    ...
    
  8. Now you can start Foxhound again.

See also...
How do I move Foxhound to a different disk drive?
How do I move the Foxhound transaction log to a different physical disk drive?


[ Top ]
Question: How do I move the Foxhound transaction log to a different physical disk drive?

Answer:

  1. Shut down Foxhound if it is running.

  2. Create a folder for the transaction log on a different physical drive; e.g., G:\data\foxhound_log

  3. Move the foxhound5.log file to that folder. By default, foxhound5.log is installed in this location on Windows 10:
    C:\ProgramData\RisingRoad\Foxhound5

  4. Run dblog.exe to modify the foxhound5.db file to point to the new location for the foxhound5.log file:

             "C:\Program Files\SQL Anywhere 16\Bin64\dblog.exe" -t "G:\data\foxhound_log\foxhound5.log" "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"
             

  5. Here's what the output looks like:

    C:\temp>"C:\Program Files\C:\Program Files\SQL Anywhere 16\Bin64\dblog.exe" -t "G:\data\foxhound_log\foxhound5.log" "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db"
    SQL Anywhere Transaction Log Utility Version 17.0.9.4882
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" was using log file "foxhound1.log"
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" is using no log mirror file
    "C:\ProgramData\RisingRoad\Foxhound5\foxhound5.db" is now using log file "G:\data\foxhound_log\foxhound5.log"
    Transaction log starting offset is 0011371032
    Transaction log current relative offset is 0474894106
    

  6. Now you can start Foxhound again.

See also...
How do I move Foxhound to a different disk drive?
How do I move the Foxhound database to a different location?


[ Top ]
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 10... 

   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 dbsrv17.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:

"%SQLANY17%\%BIN%\dbspawn.exe"^
  -f "%SQLANY17%\%BIN%\dbsrv17.exe"^
  -c 25p^
  -ch 50p^
  -cr-^
  -dt F:\data\SQL_Anywhere_temp^
  -gk all^
  -gn 220^
  -gna 0^
  -m^
  -n foxhound5^
  -o foxhound5_debug.txt^
  -oe foxhound5_debug_startup.txt^
  -on 1M^
  -sb 0^
  -ufd restart^
  -x tcpip^
  -xd^
  -xs http(port=80;maxsize=0;to=600;kto=600)^
  foxhound5.db^
  -n f
Here's the list of Foxhound command files which contain the dbsrv17.exe command:
C:\ProgramData\RisingRoad\Foxhound5\

    $backup_foxhound5.bat
    $start_foxhound5_default_browser_debug.bat
    $start_foxhound5_default_browser.bat
    $start_foxhound5_engine.bat

C:\ProgramData\RisingRoad\Foxhound5\scripts

    $create_SQL_Anywhere_17_bin64_service.bat
    $MULTI_Step_2_dbsrv_all.bat
    $MULTI_Step_2b_dbsrv_one.bat
    $run_most_recent_mini_restore.bat
    $TEN_INSTANCES_2_dbsrv.bat 


[ Top ]
Question: How do I protect the security of my target database?

Answer:

One way to protect the security of your target database is to use the HTTPS protocol. For more information see How do I specify the HTTPS transport-layer security for Foxhound?

Another technique is to create a new user id on the target database with no privileges other than CONNECT, and use that user id for Foxhound to connect:

-- Run this command on the target database:

GRANT CONNECT TO FOXHOUND IDENTIFIED BY SQL;

-- Set up a connection string like this on the String tab of the Foxhound Menu:

Name:   ddd16
String: ENG=ddd16; DBN=ddd16; UID=FOXHOUND; PWD=SQL; DRIVER=SQL Anywhere 16; 

The Display Schema feature should work OK with the new "FOXHOUND" user id. The Monitor Database feature should also work, but Foxhound's own performance might suffer because Foxhound can't create the three high-performance procedures on the target database it needs to gather performance data efficiently; in this case the Monitor page will display "SPs are OK: NNN" instead of "SPs are OK: YYY".

You can install those three procedures on the target database yourself; for step-by-step instructions see Help - Introduction - Connecting to Target Databases.

See also...
How do I specify the HTTPS transport-layer security for Foxhound?
Help - Introduction - Connecting to Target Databases


[ Top ]
Question: How do I reinstall an earlier build of Foxhound?

Answer: The regular re-installation process will work for an earlier build. HOWEVER, the post-upgrade process will NOT copy the data from your current Foxhound database to the one that's being installed when the current installed build number is later than the one that's being installed. That means you lose your sample data and option settings, and it means you will have to activate Foxhound as if it were a brand new installation.

See also...
How do I reinstall Foxhound?


[ Top ]
Question: How do I reinstall Foxhound?

Answer:


Note: A successful installation overwrites existing files. It is your responsibility to make a backup of your existing Foxhound installation if you want one. The simplest way to make a complete backup is to stop the Foxhound engine, then make a copy of the entire Foxhound5 folder and subfolders... do this BEFORE installing the new version of Foxhound.

By default, Foxhound is installed in this location on Windows 10:

C:\ProgramData\RisingRoad\Foxhound5

To reinstall Foxhound, run the InstallShield setup.

What you do next depends on which dialog box appears...


If you see a dialog box that looks like either of these, you have to run the Foxhound "unsetup" process first and then run the Foxhound InstallShield setup as described below:

Another version of this product is already installed.

Modify, repair, or remove

Do not click on Modify or Repair; they won't damage anything, but nothing will happen when you click on the Post-Setup button at the end of Modify or Repair process:

The unsetup process will not delete your Foxhound database; for more information see Another version of this product is already installed.


If you see this dialog box, you can proceed with the reinstallation:

Step 1

The post-setup process will ask how much data you want to preserve; just press Enter for ALL data:

Post-Setup Process for Foxhound Version 5.0
*** Checking for a post-setup path parameter...
*** A post-setup path parameter was provided...
C:\ProgramData\RisingRoad\Foxhound5\
*******************************************************************
***                   Foxhound 5.0.xxxx
***
*** Here's where Foxhound is being installed:
*** C:\ProgramData\RisingRoad\Foxhound5\
***
*** Starting the Foxhound 5,0.xxxx post-setup process...
*** Creating foxhound5.db.5,0.xxxx.ORIGINAL_COPY...
*** Checking for an existing Foxhound5 installation...
***  ...yes, there is an existing Foxhound5 installation.
*** Checking if the existing data should be upgraded...
***  ...yes, the existing Foxhound5 data should be upgraded.
******************************************************************
*** PLEASE READ THIS, AND CONFIRM OR CHANGE **********************
******************************************************************
***
*** "FOXHOUND5UPGRADE" specifies how much data is to be upgraded.
***
*** If you want to CHANGE the setting, type in a new value...
***    ALL       - upgrade all the data
***    OPTIONS   - no samples, just the Foxhound options
***    yyyymmdd  - options plus samples since yyyymmdd
***    nnn       - options plus last nnn days of samples
***    NOTHING   - don't upgrade any data
*** and press Enter to continue.
***
*** If you LIKE the current setting...
***    FOXHOUND5UPGRADE=ALL which means upgrade all the data
*** just press Enter.
******************************************************************
Current FOXHOUND5UPGRADE=ALL
New     FOXHOUND5UPGRADE=

For more information about how FOXHOUND5UPGRADE works see Foxhound Help - FOXHOUND5UPGRADE.


Caution: If you are using the Windows Vista or Windows 10 Task Scheduler to take regular backups of your Foxhound database using the $backup_foxhound5.bat file you should reboot your computer after installing a new version of Foxhound.

See also...
How do I install Foxhound?
How do I install a new version of Foxhound?
Another version of this product is already installed.
Why is it called "unsetup" instead of "uninstall"?
How do I remove Foxhound from my system?


[ Top ]
Question: How do I remove Foxhound from my system?
Question: How do I uninstall Foxhound?

Answer: First, stop the Foxhound database if it's running.

You can do this by clicking on start - All Programs - Foxhound5 - Tools - Stop Foxhound Engine.

Second, run the Foxhound "unsetup" process. There are three ways to do this:

  • Click on start - All Programs - Foxhound5 - Tools - Unsetup Foxhound, or
  • use the Control Panel - Add or Remove Programs dialog to remove Foxhound Version 5, or

  • run this command: MsiExec.exe /X{B0FE1886-2DBE-4269-8EBD-2A3EF45C4EF5}

Third, delete the Foxhound5 folder and all the files and subfolders.

By default, Foxhound is installed in this location on Windows 10:

C:\ProgramData\RisingRoad\Foxhound5

See also...
How do I install Foxhound?
How do I install a new version of Foxhound?
How do I reinstall Foxhound?
Another version of this product is already installed.
Why is it called "unsetup" instead of "uninstall"?


[ Top ]
Question: How do I rename a connection string on the String tab of the Foxhound Menu page?

Answer:

There is no "Rename" button; you have to copy-and-save and then delete:

  1. Select the connection string with the old name on the String tab of the Foxhound Menu page.

  2. Type the new name in the "Name:" field.

  3. Click on the Save button.

  4. Select the connection string with the old name again.

  5. Click on the Delete button.


[ Top ]
Question: How do I renew the Rental Edition of Foxhound 5?

Answer:

Step 1: Get 30-day Rental Key; see How do I get a copy of Foxhound?

Step 2: Open the Foxhound About page.

Step 3: Click on the "Renew or Upgrade Foxhound" button to open the Foxhound Activation page, and follow the instructions.

See also...
How do I get a copy of Foxhound?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?


[ Top ]
Question: How do I report unexpected errors and exceptions?

Answer:

First, use the Foxhound Options - Diagnostics - Display Diagnostics button to see if there are any diagnostic messages associated with this problem. If so, use the Export Diagnostics button to copy the Foxhound diagnostic messages to a text file.

C:\temp\foxhound_diagnostics.txt
Then, run this adhoc query to determine if Foxhound has captured any diagnostic dumps associated with those diagnostic messages; see How do I run adhoc queries on the Foxhound database?
SELECT exception_id, 
       dump_id,  
       dump_inserted_at
  FROM exception_dump
 ORDER BY exception_id,
       dump_id;
If so, run this adhoc query to copy the diagnostic dumps to another text file:
SELECT *
  FROM exception_dump
 ORDER BY exception_id,
       dump_id;
OUTPUT TO 'C:\temp\foxhound_dumps.txt';
Finally, send both files to Breck.Carter@gmail.com

See also...
Help - Foxhound Options - Diagnostics
How do I run adhoc queries on the Foxhound database?


[ Top ]
Question: How do I restore the old build of Foxhound after installing a new build?

Answer: Foxhound's executable code is stored together with Foxhound data inside the Foxhound database, so "restoring the old build of Foxhound" is the same as "restoring the old Foxhound database".

The post-setup process creates a backup copy of your existing Foxhound database, and you can restore that copy by copying the foxhound.db and foxhound.log files as follows:

On Windows 10, copy the foxhound.db and foxhound.log files from:
C:\ProgramData\RisingRoad\Foxhound5\backup\previous_build
to:
C:\ProgramData\RisingRoad\Foxhound5


[ Top ]
Question: How do I run the Foxhound "unsetup" process?
Question: How do I "unsetup" Foxhound?

Answer: There are three ways to run the Foxhound "unsetup" process:

  • Click on start - All Programs - Foxhound5 - Tools - Unsetup Foxhound, or
  • use the Control Panel - Add or Remove Programs dialog to remove Foxhound Version 5, or

  • run this command: MsiExec.exe /X{B0FE1886-2DBE-4269-8EBD-2A3EF45C4EF5}

See also...
Why is it called "unsetup" instead of "uninstall"?
How do I remove Foxhound from my system?


[ Top ]
Question: How do I "Save As" an existing connection string to a new string with a different name on the String tab of the Foxhound Menu page?

Answer:

There is no "Save As" button; you have to change the name and then save:

  1. Select the existing connection string on the String tab of the Foxhound Menu page.

  2. Type the new name in the "Name:" field.

  3. Click on the Save button.


[ Top ]
Question: How do I see Foxhound diagnostics, errors and exceptions?
Question: How do I read the Foxhound exception messages?

Answer:

You can use Foxhound Options - Display Diagnostics to see messages recorded by Foxhound itself.

Here is an example of a Foxhound exception message with an explanation of the different sections:

exception id: 1, 2, 3...
|   date and time of the exception
|   |                       Foxhound build number
|   |                       |                Foxhound connection number that detected the exception
|   |                       |                |          exception location within Foxhound code
|   |                       |                |          |              diagnostic text: variable format              target database id and name
|   |                       |                |          |              |                                                                    |
67  2011-11-11 11:49:08.768 Full Build 4013a 1000009471 701.a3(701eh1) Permission denied: Cannot CREATE PROCEDURE rroad_engine_properties. [5-ddd12]

For more information about errors during Foxhound startup, try using one of the "debug" scripts; see Help - Introduction - Starting Foxhound - Method 2: Debug Startup.

See also...
How do I report unexpected errors and exceptions?
How do I figure out what went wrong during an installation?


[ Top ]
Question: How do I shrink the size of the Foxhound database?

Answer:

One method is to use the Foxhound upgrade process to purge old sample data by reinstalling Foxhound and specifying FOXHOUND5UPGRADE = yyyymmdd or nnn when the prompt appears during the post-setup process. For more information see

How do I reinstall Foxhound?

Even if you use a very old value of FOXHOUND5UPGRADE = yyyymmdd or a very large value of FOXHOUND5UPGRADE = nnn to copy all of the sample data, the Foxhound database will probably shrink somewhat because the reinstallation process removes free space.

Another method is to let the purge process delete old and/or uninteresting sample data and then reinstall Foxhound as follows:

  • Use the Foxhound Options - Purge Process feature to speed up the deletion of old sample data.
  • Wait until the background purge process has had enough time to increase the amount of free space to the level you want; for example, from 2% to 75%.

    This may take a few hours or even days if you have a lot of data to delete; watch the amount of free space displayed by the Foxhound Options - Purge Process feature.

  • Reinstall Foxhound following these instructions.

    This process will create and reload a new Foxhhound database with just the remaining data and much less free space.

See also...
How do I reinstall Foxhound?
Help - Foxhound Options - Purge Process


[ Top ]
Question: How do I specify the HTTPS transport-layer security for Foxhound?

Answer: You can modify the Foxhound startup command line to specify RSA encryption and the HTTPS protocol as follows:

  • Obtain an identity certificate and the associated private key for your Foxhound installation.
  • Store the identity certificate file in a known location.

  • Change the -xs option to specify https on the dbsrv17.exe command line used to start Foxhound.

    Specify the identity certificate file and private key in the -xs https identity= and identity_password= parameters.

    Note that the default port for HTTPS is 443.

Here is an example of a dbsrv17.exe command line modified to allow only HTTPS access to Foxhound data using the sample certificate that comes with SQL Anywhere 17:

"%SQLANY17%\%BIN%\dbspawn.exe"^
  -f "%SQLANY17%\%BIN%\dbsrv17.exe"^
  -c 25p^
  -ch 50p^
  -cr-^
  -gk all^
  -gn 220^
  -gna 0^
  -m^
  -n foxhound5^
  -o foxhound5_debug.txt^
  -oe foxhound5_debug_startup.txt^
  -on 1M^
  -sb 0^
  -ufd restart^
  -x tcpip^
  -xd^
  -xs https(identity="%SQLANYSAMP17%\Certificates\rsaserver.id";identity_password=test;port=443;maxsize=0;to=600;kto=600)^
  foxhound5.db^
  -n f

If you want to allow both HTTP and HTTPS access, specify both as follows:

  -xs http(port=80;maxsize=0;to=600;kto=600),https(identity="%SQLANYSAMP17%\Certificates\rsaserver.id";identity_password=test;port=443;maxsize=0;to=600;kto=600)^
Here's the list of Foxhound command files which contain the dbsrv17.exe -xs option:
C:\ProgramData\RisingRoad\Foxhound5\

    $backup_foxhound5.bat
    $start_foxhound5_default_browser_debug.bat
    $start_foxhound5_default_browser.bat
    $start_foxhound5_engine.bat

C:\ProgramData\RisingRoad\Foxhound5\scripts

    $create_SQL_Anywhere_17_bin64_service.bat
    $MULTI_Step_2_dbsrv_all.bat
    $MULTI_Step_2b_dbsrv_one.bat
    $run_most_recent_mini_restore.bat
    $TEN_INSTANCES_2_dbsrv.bat 

See also...
How do I tell Foxhound to use an HTTP port other than 80?


[ Top ]
Question: How do I stop the "User Id:" and "Password:" from being redisplayed on the Foxhound Menu page?
Question: Why are the "User Id:" and "Password:" values redisplayed after I blank them out on the Foxhound Menu page?

Answer:

If you are using Firefox as your browser, try removing http://localhost from Foxhound's list of Saved Logins:

Options (gear icon)
   Privacy & Security tab
      Logins and Passwords section
         Saved Logins... button
            select Site http://localhost
               Remove button


[ Top ]
Question: How do I tell Foxhound to use an HTTP port other than 80?

Answer: You can edit one or more of the following Windows command files to specify a different HTTP port:

C:\ProgramData\RisingRoad\Foxhound5\

    $backup_foxhound5.bat
    $start_foxhound5_default_browser_debug.bat
    $start_foxhound5_default_browser.bat
    $start_foxhound5_engine.bat

C:\ProgramData\RisingRoad\Foxhound5\scripts

    $create_SQL_Anywhere_17_bin64_service.bat
    $MULTI_Step_2_dbsrv_all.bat
    $MULTI_Step_2b_dbsrv_one.bat
    $run_most_recent_mini_restore.bat
    $TEN_INSTANCES_2_dbsrv.bat 
Look for a line inside each command file that says this:
-xs http(port=80;maxsize=0;to=600;kto=600)^
and change the 80 to something else, like 12345:
-xs http(port=12345;maxsize=0;to=600;kto=600)^
Then, look for a line that says this:
http://localhost/foxhound
and if you find it (all the "chrome", "firefox" and "ie" command files have it) change it like this:
http://localhost:12345/foxhound

See also...
How do I specify the HTTPS transport-layer security for Foxhound?
What HTTP port should I use for Foxhound?
IANA port number assignments
Can't start HTTP listener on address 127.0.0.1:80
Database server shutdown due to startup error


[ Top ]
Question: How do I upgrade Foxhound from one edition to another?

Answer:

It depends on what you want to do...

See also...
How do I get a copy of Foxhound?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?


[ Top ]
Question: How do I upgrade from the Basic Edition of Foxhound 5 to the Extended Edition?

Answer:

Step 1: Get a Basic To Extended Key; see How do I get a copy of Foxhound?

Step 2: Open the Foxhound About page.

Step 3: Click on the "Upgrade Foxhound" button to open the Foxhound Activation page, and follow the instructions.

See also...
How do I get a copy of Foxhound?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?


[ Top ]
Question: How do I upgrade from the Rental Edition of Foxhound 5 to the Basic Edition?

Answer:

Step 1: Get a New Basic Key; see How do I get a copy of Foxhound?

Step 2: Open the Foxhound About page.

Step 3: Click on the "Renew or Upgrade Foxhound" button to open the Foxhound Activation page, and follow the instructions.

See also...
How do I get a copy of Foxhound?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?


[ Top ]
Question: How do I upgrade from the Rental Edition of Foxhound 5 to the Extended Edition?

Answer:

Step 1: Get a New Extended Key; see How do I get a copy of Foxhound?

Step 2: Open the Foxhound About page.

Step 3: Click on the "Renew or Upgrade Foxhound" button to open the Foxhound Activation page, and follow the instructions.

See also...
How do I get a copy of Foxhound?
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
What are the differences among all the activation keys?


[ Top ]
Question: How many target databases can one copy of Foxhound monitor?

Answer: A single copy of the Basic edition of Foxhound is limited to monitoring 10 target databases, and the Extended edition can monitor up to 100 target databases.

However, the Extended Edition of Foxhound does not limit the number of separate copies of the Foxhound database that may be created and started using separate instances of SQL Anywhere on the same local network; see Help - Introduction - Starting Multiple Copies of Foxhound.

Note: Here's what the End User License Agreement has to say...

In the case of the Extended Edition, an unlimited number of copies of the Foxhound database may be created and started using separate instances of SQL Anywhere on the same local network, with the requirement that a separate Extended Edition registration key be purchased for each multiple of 10 copies of Foxhound started.

See also...
Help - Introduction - Starting Multiple Copies of Foxhound
What are the differences among the different editions of Foxhound: Rental, Basic and Extended?
Help - Introduction - End User License Agreement


[ Top ]
Question: How much overhead does the Foxhound connection add to the target database?

Answer:

Note: This FAQ does not discuss the impact of running the Foxhound database on the same computer as the target database. If both databases are heavily loaded it is probably a good idea to move Foxhound to a different computer.

Foxhound's overhead is approximately the same as a single persistent ODBC client-server connection that performs a small-to-medium (depending upon your point of view) amount of read-only query requests (three SELECTs) every ten seconds. The "Sample Times" column on the Monitor page shows how long it takes for Foxhound to do its work.

Generally speaking, if Foxhound's overhead causes any problems, the target database is already in serious difficulty for other reasons.

You can see the Foxhound connection in Foxhound itself; e.g., Foxhound-p001. It's not "zero impact" but it's not a heavy load either. The overhead goes up linearly with the number of other connections to the target database. For example, I have seen the CPU usage rise to 4% on a target database with 1000 idle connections; i.e., Foxhound was using 4% of the target server's CPU to gather information about 1000 connections every 10 seconds, even though those connections aren't doing anything.

Foxhound's overhead affects the CPU and client-server communications only; Foxhound performs no database disk I/O on the target database.

The Foxhound Monitor does almost all of its work inside its own SQL Anywhere server, so if you run that server on a different computer the impact on the target database server will be minimized. On the other hand, if you run Foxhound on the same box, and your target database is heavily loaded with a lot of connections, you can run into trouble.

Historically, Foxhound itself has had internal performance problems from time to time, but there has never been clear evidence of Foxhound adversely affecting a *target* database. "Clear evidence" would be a target database that performs well without Foxhound, and performs poorly with Foxhound.

One other factor has a large impact on Foxhound's own internal efficiency; here's a description:

In the status area of the Monitor page (just below the buttons), there is an SP OK: field over to the right. SPs OK: YYY, NNN or some combination of Ys and Ns indicates whether or not Foxhound has deployed, and is using, these three stored procedure on the target database: rroad_connection_properties, rroad_database_properties and rroad_engine_properties.

These stored procedures are used by Foxhound to improve the performance of the sampling process, but they are not absolutely required. If the user id that Foxhound uses to connect to the target database doesn't have the RESOURCE authority then Foxhound won't be able to CREATE these procedures on the target database.

The source code for the three procedures is in the Foxhound5 folder (C:\ProgramData\RisingRoad\Foxhound5 on Windows 10) so you can see what they do yourself:

rroad_connection_properties.sql
rroad_database_properties.sql
rroad_engine_properties.sql

The effect of these procedures is to reduce the number of rows of data, and the number of bytes, transferred from the target database to Foxhound every 10 seconds. That, in turn, has a significant effect on Foxhound itself if there a large number of connections. When those procedures are not available on the target database, Foxhound calls these three system procedures on the target database every ten seconds: sa_conn_properties(), sa_db_properties() and sa_eng_properties().

For more information about these procedures see Help - Introduction - Connecting to Target Databases.


This page was last generated on July 17, 2020. Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com