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)