Topic Last Modified: 2007-02-01

Procedure

This topic explains how to set up an open database connectivity (ODBC)-compliant database.

To set up an ODBC-compliant database

  1. Create an ODBC-compliant database by using a database program, such as Microsoft Access or Microsoft SQL Server.

  2. Create a table in the database that contains the fields listed in the following table.

    Field name Data type

    ClientHost

    varchar(255)

    Username

    varchar(255)

    LogTime

    datetime

    Service

    varchar(255)

    Machine

    varchar(255)

    ServerIP

    varchar(50)

    ProcessingTime

    integer

    BytesRecvd

    integer

    BytesSent

    integer

    ServiceStatus

    integer

    Win32Status

    integer

    Operation

    varchar(255)

    Target

    varchar(255)

    Parameters

    varchar(255)