ODBC Logging (IIS 6.0)
ODBC logging records a fixed set of data fields in an ODBC-compliant database, such as Microsoft® Access or Microsoft® SQL Server™. With ODBC logging, you must set up a database to receive the data, and then specify this database as the database to which log files should be recorded.
When ODBC logging is enabled, IIS disables the HTTP.sys kernel-mode cache. For this reason, implementing ODBC logging will degrade overall server performance. ODBC logging is not recommended unless your database limits you to this option.
IIS includes a Structured Query Language (SQL) template file that you can run in a SQL database to create a table that accepts log file entries from IIS. The file is named Logtemp.sql, and it is located in the systemroot\System32\Inetsrv directory by default.
For security reasons, do not use the well-known SQL Server administrator account name SA for ODBC logging. If a malicious user accessed the worker process, that user could use the SA account to access the SQL Server. Remove the SA account, and create a new account with the least necessary rights. For more information, see .
Table 10.7 lists the fields, data types, and descriptions of the fields recorded in the ODBC logging format.