The H2OS Recovery Console

 

The H2OS Recovery Console is an executable included with the H2OS installation (C:\H2OS\H2OS_RECOVER.EXE) or can be downloaded from the H2OS Website

 

 

To launch the H2OS recovery console use Windows Explorer. Navigate to find and launch the recover program (C:\H2OS\H2OS_RECOVER.EXE)  

 

The Recovery Console screen:

 

 

 

 

Figure 1  The H2OS Recovery Console

 

The H2OS recovery console provides access to some features which can be helpful to recover from a system failure

 

 

Launching the H2OS Recovery Console

 

The H2OS Recovery Console is installed in the H2OS root (installation) folder

 

The H2OS Recovery Console can be started using Windows Explorer. To do so, locate and double-click the file name c:\h2os\h2os_recover.exe. You can also copy the desktop shortcut provided as a file named "c:\h2os\h2os recover (file type is "Shortcut")" to your desktop using Windows Explorer.

 

 

 

 

Command

 

Explanation
 

 

Apply database structure changes

 

Checks to see that all database structure changes distributed to date have actually been installed on this H2OS installation. If changes have been made, no action is taken. If change had not been made it will be made during the next H2OS startup.

 

 

Browse or Edit a database table

 

 

 

 

Click the command button to the right to use the Windows navigator to select a table (DBF) to be viewed. The selected

DBF table name will appear in this textbox.

 

When a table has been selected, click the EDIT or BROWSE command button below the selected table name

 

 

Change the current database

 

 

This command use the Windows Navigator to select the H2OS Customers table (REALCUS.DBF) to be opened during the next H2OS startup.

 

In most installations the customer table is located at c:\h2os\cl\h2os\realcus.dbf. For multiple H2OS installations the root folder name will be different for each installation, e.g. H2OS_MYCO, H2OS_YOURCO, etc.

 

The Customers table is sometimes referred to as CUSTLIST

 

Internally, this command will change the Operators profile to make the selected customers table the current database when H2OS is re-started.

 

 

Command window

 

 

Launches a Visual FoxPro command window. Use only on advice from H2OS customer support. To close this window enter QUIT.

 

 

Disconnect from LAN

 

 

When reconnecting to LAN server, use setup->options->network to re-designate this computer as a LAN Workstation and point to the LAN server containing the shared H2OS database.

 

This option will release LAN connections and switch this computer from running H2OS as a LAN workstation to a standalone installation using the local (on this machine) H2OS database installation's files and not those on the LAN server.

 

For more information on the location of files involved, see the distribution of files topic

 

 

Fallback to last H2OS release

 

Renames current executable so it will not be located during startup, which will cause startup to run the immediately preceding release (assuming the previous release EXE still exists in the C:\H2OS folder).

 

For example, if you have these versions of H2OS installed:

 

LS051510.EXE

LS051511.EXE

LS051512.EXE

LS051513.EXE

 

The current executable (version) is LS051513.EXE, the highest number executable.

 

By renaming this executable, H2OS will find and launch the now highest version number, LS051512.EXE

 

The renamed executable will appear ls LX051513.EXE

 

 

 

 

H2OS Online Help

 

 

 

 

Launch your Internet browser to view the online copy of the H2OS Customer Guide

 

Restore a full H2OS created backup

 

 

Restore the H2OS database from an H2OS created backup.

 

H2OS backups are initially stored in the BACKUPS folder designated by setup->options->backups

 

Recover will ask you to point to the backup to be restored and the root folder to restore into.

 

 

Reset current database

 

 

If it appears that the problem is that H2OS cannot find or connect with the customers database table, you have 2 options using the Recovery Console.

 

Option 1:  Switch the current database table to a test (sample) database table (using this command) to start H2OS, then make changes to correct the problem and then switch the current database to your actual customers database table.

 

Clicking this command will switch the current Customers database to a sample database that was installed with H2OS, which should permit H2OS to start.  Once started, it may be possible to correct the problem and then use the FILE menu to select and open (connect) your actual  customers database table.

 

Option 2: use the "Change current database" command to use the Windows Navigator to point to the H2OS customers table to be used

 

Option 3: Restore an H2OS created backup

 

Option 4: Disconnect from LAN. If this computer is an H2OS LAN Workstation, this command will disconnect this computer from the designated server and to access the H2OS installation on this computer.

 

 

 

 

Restore default tab pages

 

Click to restore H2OS tab pages to a minimum set of tab pages.  

 

This option is provided in case it's obvious H2OS is failing to start due to a tab page problem. By changing the tab pages displayed to just a few basic pages this error can be bypassed to get H2OS started and to select tab pages to be displayed (excluding the failing page)

 

 

Restore default menu system

 

 

Restore the H2OS menu system to the default system (as shipped)

 

Turn off the H2OS automatic backup option

 

 

Turn off automatic backup

 

To eliminate the possibility that taking a backup during startup is causing or in some way exacerbating a problem.

Later, when H2OS starts, you can use setup->options->backup to turn this option back on.

 

 

Turn off TIPS at started

 

Stops tips from being automatically displayed during H2OS startup

 

 

 

 

 

Browse or edit a database table

 

Enter, select from the pulldown menu, or use the ellipsis (...) command to use the Windows navigator to point to the table (xxxx.dbf) to be browsed or edited

 

 

Command

Use for

 

Edit

 

 

To view the table in edit mode, which allows you to make changes to the table

 

 

Browse

 

 

To view the table in read-only mode

 

 

Using the recovery console

If H2OS fails to start for any reason,  Click H2OS Recover shortcut on your desktop

 

The Recovery Console can be used to make changes to your H2OS database without H2OS running at the time. This makes certain types of changes possible that would not be permitted if H2OS is running.