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.
Create an ODBC-compliant database by using a database program such as Microsoft Access or Microsoft SQL Server-TM-.
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) |