Database
Disk Triage provides the ability to save sizing information to a database. The database use is the Advantage Database from Extended Systems. This database was chosen for a variety of reasons:
- It is small and easy to install with the applicaiton
- It is free to distribute the local engine
- It is fast and easy to work with
- It provides both ADO and ODBC drivers
What does this mean to a user of Disk Triage?
- Small footprint on your system when installed
- It does not install a complete database system on your PC. It only installs a DLL in the Disk Triage installation directory
- It provides a way (via ADO/ODBC) for the user to access the sizing data from their favorite database tool - such as Microsoft Access, Corel Paradox, etc..
How to get the ODBC/ADO drives?
You can download the drivers from the following links
Configuration of ODBC Driver
The ODBC driver once installed - needs to be configured. Disk Triage allows you to create and maintain multiple databases - so you will need to setup an ODBC DNS entry for each Database you want to access. The following screen shots shows the settings you need to configure in order to have the ODBC driver correctly access the Disk Triage data.
There are two critical settings that must be set properly. The first is the Available Server types in the lower right hand corner. It MUST include the Local Server (ALS) entry. In the above screen shot that is the only one that is selected. The second critical setting is in the 'Database or Data Dictionary Path' group box in the middle of the screen. Here you need to specify Data Dictionary by making sure the checkbox is checked - and then you need to select the *.ADD file for the database you want to access. In Disk Triage - each database you create (including the DB1 database that is setup by default) creates its own sub-directory under the DiskTriageDB.add file that is the one you need to select. Note that you must have the checkbox selected - or the ODBC driver will only allow you to select directories.
Using RDP to Run Disk Triage - Need another line in ADS.ini file
The database that Disk Triage uses makes use of a file called ADS.ini for its configuration settings. If you are running DiskTriage on a server and accessing it via RDP you need to add one line to your ADS.ini file. It is the line below that is bolded - MTIER...
[SETTINGS]
COMMCALLTRACE=1
MTIER_LOCAL_CONNECTIONS=1