Database - Advantage & Microsoft SQL Server
Disk Triage provides the ability to save sizing information to a database. It can use either MS SQL Server or the Advantage Database. The Advantage Database is great for stand alone installs. The MS SQL Server is great for larger companies that want to share the information amoung multiple users.
Microsoft SQL Server
We assume that if you are using MS SQL Server you know how to get the latest ODBC and other drivers from Microsoft and configure it for use with Disk Triage with some assistance from our Help Files. However, as the Advantage Database is a little different - we have included the following instructions.
Advantage Database
How to get the ODBC Driver
You can download the drivers from the following links:
ODBC Driver
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.
Microsoft SQL Server
We assume that if you are using MS SQL Server you know how to get the latest ODBC and other drivers from Microsoft and configure it for use with Disk Triage with some assistance from our Help Files. However, as the Advantage Database is a little different - we have included the following instructions.
Advantage Database
How to get the ODBC Driver
You can download the drivers from the following links:
ODBC Driver
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
You will also need to set an Environment Variable to enable Disk Triage to know which ADS.ini file to access.
adsini_path = Path to the file
ie
adsini_path = c:\Program Files\TimeAcct\DiskTriage