Avaya

Modular Messaging Help

 Getting Started 
 Installation 
 Administration 
 Maintenance 
 Reference 
Home > MAS Administration > MAS - RT - Selecting a Data Source

MAS - RT - Selecting a Data Source

If the Reporting Tool is installed on the tracing system machine, a data source is created automatically. If not, you need to select a system data source before you can use the Reporting Tool.

Note: If you are using Microsoft Windows Vista, you need to be logged into Windows as an administrator to create a new data source.

Procedure 1: Sharing Out the Transaction Database Directory

On the MAS, or supplementary server, that is running the Tracing Server software, you must share out the directory in which the transaction database resides.

  1. In Windows Explorer, locate the directory in which the transaction database (TrxDB.mdb) resides.
  2. By default the path to this directory is: C:\Program Files\Avaya Modular Messaging\Tracing\

  3. Right-click the Tracing directory and, from the pop-up menu, select Sharing & Security.
  4. The system displays the Tracing Properties dialog box.

  5. On the Sharing tab, select the Share this folder option.
  6. Click Permissions.
  7. The system displays the Permissions for Tracing dialog box.

  8. Select Everyone and make sure that at least the Read permission is set.
    Note: The other settings may be set at your discretion.
  9. In the Permissions for Tracing dialog box, click OK.
  10. In the Tracing Properties dialog box, click Apply.
  11. In the Tracing Properties dialog box, select the Security tab.
  12. Verify that any users who will be using the Reporting Tool have the following permissions set:
    • Read & Execute
    • List Folder Contents
    • Read
  13. In the Tracing Properties dialog box, click OK.
  14. Right-click the TrxDB.mdb file and, from the pop-up menu, select Properties.
  15. In the TrxDB.mdb Properties dialog box, select the Security tab.
  16. Verify that any users who will be using the Reporting Tool have the following permissions set:
    • Read & Execute
    • List Folder Contents
    • Read
  17. In the TrxDB.mdb Properties dialog box, click OK.

Procedure 2: Creating a New Data Source

  1. If you need to share out the directory in which the transaction database resides, follow “Procedure 1”, above.
  2. On your Windows desktop, click the Start > Programs > Avaya Modular Messaging > Reporting Tool menu to launch the Reporting Tool window. See MAS - Reporting Tool Window.
  3. Click File > Source....
  4. The system displays the standard Windows ODBC Data Source Administrator dialog box.

  5. Click the System DSN tab.
  6. Click the Add... button.
  7. The system displays the standard Create New Data Source dialog box.

  8. Click Microsoft Access Driver (*.MDB) and click Finish.
  9. The system displays the standard ODBC Microsoft Access Setup dialog box.

  10. In the Data Source Name field, type TrxDB.
  11. Click the Select... button.
  12. The system displays the standard Select Database dialog box.

  13. Map a drive to the transaction database (TrxDB.mdb).
    1. Click the Network... button.
    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 database (TrxDB.mdb) 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, or supplementary server, on which the Tracing Server software is running.

      • Use the Browse... button to locate the Tracing directory on the MAS, or supplementary server, on which the Tracing Server software is running.
    4. Click Finish.
  14. In the Select Database dialog box, set the Drives field to the drive you mapped in the previous step.
  15. The system displays in the Database Name field a list of one or more databases on the mapped drive. The transaction database (TrxDB.mdb) should be among them.

  16. Select TrxDB.mdb.
  17. Click OK.
  18. In the ODBC Microsoft Access Setup dialog box, click OK.
  19. In the ODBC Data Source Administrator dialog box, click OK.

Top of page