Writing Log Information to a Database

When database logging is selected, a database must exist and be installed as an ODBC database. The configuration must hold the database source name (DSN) and table name for that database if the logging is to work.

To select database logging through the WTE administration object model, set the WTELog.LogType property to wteLogToSql.

The following parameters determine the logging configuration when logging on to an ODBC database:

Database Source Name

The DSN is the name of the ODBC database source as installed on the computer. To specify the database source programmatically, use the WTELog.LogSqlDataSource property.

Table Name

The table name is the name of the table to which WTE writes the log. To specify the table name programmatically, use the WTELog.LogSqlTableName property.

Microsoft supplies two log databases that are ready to use with WTE, one for Access 97 and the other with Access 2000. These databases are located in the \Samples\odbc\access directory of the Platform SDK. You can import either of these databases into the SQL server.