Log Files and Access

[adamdedrick]

Is there any general solution for getting iis log files imported into a database so they can be analysed.

Thanks

 

[rewebb]

I would say there are two solutions.

One would to write the log files directly to a database by selecting "ODBC Logging" instead of "W3C Extended log file format" or "NCSA Common log file format". You will also need to create a DSN or this to work. Be aware that this will put more load on the web server.

The other solution is to import the comma delimited log file into Access.

 

[adamdedrick]

Thanks for the ideas but what I am after is a general purpose import routine for access that will read the log file types that IIS supports and populate a database, taking note of the field definitions in the log file.
I have used the ODBC logging for development and it is really helpful, but no good on a live server due to performance.

So if anyone knows of some reasonable code to do this, otherwise I am going to have to write one myself and that might take a while.

Thanks

Adam

 

[LesleyW]

I've seen the output from Net Tracker on log files and found it pretty comprehensive.

Go to

http://www.sane.com

to download an evaluation copy