Avaya

Modular Messaging Help

Print | Back | Fwd | Close
Home | Search | Site Index
 Getting Started 
 Administration 
 Maintenance 
 Reference 
Home > MAS Administration > Selecting a data source

Selecting a data source

If Reporting Tool and the tracing system are not installed on the same machine, you must select a system data source that references the transaction database on the tracing system machine.

To select a data source:

  1. In the Reporting Tool window, click File > Data Source from the Reporting Tool.

    2. The system displays the standard Windows ODBC Data Source Administrator dialog box.

  2. Click the System DSN tab.
  3. In Data Source Name, click TrxDB.
  4. Click Add.

    5. The system displays the Create New Data Source dialog box.

  5. Click Microsoft Access Driver.
  6. Click Finish.

    7. The system displays the ODBC Microsoft Access Setup dialog box.

  7. On the MAS that is running the Tracing Server software, share out the directory in which the Reporting Tool Transaction database resides:
    Note: If you have already shared out this directory, (for example, for the Operation History database), then you may skip all of Step 7.
    1. In Windows Explorer, locate the directory in which the Transaction database (named trxdb.mdb) resides. By default the path to this directory is: C:\Program Files\Avaya Modular Messaging\Tracing\
    2. Right-click the Tracing directory and, from the pop-up menu, select Sharing...

      3. The system displays the Tracing Properties dialog box.

    3. On the Sharing tab, select the Share this folder option.
    4. Click Permissions.

      5. The system displays the Permissions for Tracing dialog box.

    5. Select Everyone and make sure that at least Read permissions is set.
      Note: The other settings may be set at your discretion.
    6. In the Permissions for Tracing dialog box, click OK.
    7. In the Tracing Properties dialog box, click OK.
    8. Right-click the Tracing directory and, from the pop-up menu, select Properties.
    9. Select the Security tab.
    10. Verify that any users who will be using the Reporting Tool have the following permissions set:
        • Read & Execute
        • List Folder Contents
        • Read
    11. Click OK.
    12. Right-click the trxdb.mdb file and, from the pop-up menu, select Properties.
    13. Verify that any users who will be using the Reporting Tool have the following permissions set:
        • Read & Execute
        • List Folder Contents
        • Read
    14. Click OK.
  8. In the Reporting Tool window (back on the MAS running the Reporting Tool software), click Select.

    9. The system displays the standard Select Database dialog box.

  9. Map a drive to the Transaction (trxdb.mdb) database:
    1. Click Network...
    2. In the Drive: field, select a drive letter that has not already been used on this MAS.
    3. Enter the path to the Transaction (trxdb.mdb) database by doing one of the following:
      • In the Folder: field, type the pathname using the format

        • \\servername\Tracing

        where servername is the domain name of the MAS on which the Tracing Server software is running.

      • Use the Browse... button to locate the Tracing directory on the MAS on which the Tracing Server software is running.
    4. Click Finish.
  10. In the Select Database dialog box, set the Drives field to the drive you mapped in the previous step.

    11. The system displays in the Dababase Name field a list of one or more databases on the mapped drive. The Transaction (trxdb.mdb) database should be among them.

  11. Select trxdb.mdb.
  12. Click OK.
  13. In the ODBC Microsoft Access Setup dialog box, click OK.
  14. In the ODBC Data Source Administrator dialog box, click OK.

Top of page

Home | Search | Site Index | Print | Back | Fwd | Close

©2004 Avaya Inc. All rights reserved. Last modified: