[thelist] ODBC Text Driver w/ ColdFusion

[.jeff]

John,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: John Handelaar
>
> % i'm using the merant odbc text driver that comes with
> % cf5 to query log files.  i'm looping over the query
> % results and creating individual log files for each
> % unique http_host.  i'm running into a problem though.
> % it appears as if the http_host column can't handle
> % more than 22 characters.
>
> Talking to someone I know is more versed in this
> stuff than I here, but have you tried getting IIS
> to use ODBC logging in the first place?  Left brain
> tells me that native-to-native might work better.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

I hadn't considered doing ODBC logging.  My gut says that writing to a text file would be a heck of a lot faster than doing a database hit though.

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> And of course if you're not, this suggestion wouldn't
> help with older logs - unless convlog can help?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

I'm looking for sort of an intermediate step between the logging and the reporting steps with the bonus of having combined log files for all sites running on the same service (to get an overall feeling of usage at the service provider level) and split logs to do reporting for each client using the service along with raw logs available to them to run their own reporting should they want to.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/