IIS Logging to MySQL

Hello all, I am trying to setup IIS 6 to log to a MySQL database. I have the ODBC driver installed, and have tested it to verify that it is connecting. What I would like to know is , is it possible to do this? I setup a site and configured it to use a table in the DB, but whenever I restart IIS, all I get is page cannot be displayed.

Kevin

Look in the MySQL docs for the various options you can use on your connection. There are some options you might need to set to get the driver to work more like a MS ODBC driver.

I've never tried IIS logging to a database. Isn't there some more error information on your error page?

Thanks, I figured it out. Mis-typed the DSN name, oops. But after a little research I fond that MS said that there is a major performance hit by logging this way. The said that hi traffic servers should not use ODBC logging. Guess I will have to learn how to import log files into MySQL.

Kevin

There are a lot of log analyzer programs, some are free. It's possible one or more of them already import into a db. There is a decent analyzer on sourceforge but I don't recall the name.