Share via


Setting Up an ODBC-Compliant Database

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1

This topic describes how to set up an open database connectivity (ODBC)-compliant database for protocol logging.

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

  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)