Yeah, that is what we are doing now... we are setting it up. We ran the
setup of direct SQL/ODBC logging for about a week... it is way too unstable.
We have no choice now but to do it that way. I don't really know which
component to blame thought... IIS or PostODBC? :) Hehe, think I'll go for
IIS :) Because we are not having much troubles with PostODBC with other
- Jonathan Marchand
> I think you would see improved performance and stability if you dump the
> log to a regular file (the default setting) and then run a nightly process
> dump the old files to the database.
> This has the advantage of being more reliable (fewer points of failure)
> also faster, since the speed of logging affects the web server speed.
> -Mark Radulovich
> Jonathan Marchand writes:
> Hi there,
> Anyone has experience with IIS4 (SP6a) and ODBC logging for websites? I'm
> logging about 150 websites to an SQL (postgres/linux) database thru ODBC.
> But for some reasons, IIS sometimes crash. I get a Dr. Watson screen and
> just tells me that inetinfo has died.
> I get some very strange errors in event viewer too. I get:
> IIS ODBC Logging failed to log data to data source iis_logging.
> many many times :) and sometimes it just resumes:
> IIS ODBC Logging resumed logging to data source iis_logging.
> But the thing is that I did not stop my SQL server in the meantime. I
> can't find what is the problem. And it is the only thing I found out that
> might cause IIS to hang. I checked on the linux box, and I have lots of
> postgres process doing nothing... They were started at the exact same
> time I get the errors in Event Viewer. I just kill them from time to time.
> (making a script to do so now)
> The SQL server is on the same 100mb ethernet segment. The connectivity
> between the hosts is just fine. And basically, the SQL just does that: iis
> logging :)
> I think this might be a problem with the ODBC driver on the NT box. I've
> been told that the ODBC driver runs into the same memory space as IIS. I'm
> running version 6.50.0000 of the ODBC driver.
> I'd like to be able to supply more informations (traces, memory dumps or
> if you can provide me with some instructions on how to do these, I'll do
> So please, if you have any workaround for this, I'd appreciate your input
> Or maybe, just a hint :) ODBC logging works really nice other than that,
> wrote a set of scripts that generate stats from the logs etc :)
> Jonathan Marchand
> Network Administrator
> WebNet Inc. - ISP
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
In response to
pgsql-interfaces by date
|Next:||From: Tim Uckun||Date: 2000-07-12 19:18:36|
|Subject: ODBC and long object names.|
|Previous:||From: Bob Kline||Date: 2000-07-12 18:28:01|
|Subject: Re: Re: Subject: IIS4 ODBC LOGGING TO POSTGRES - CRASH
HELP :) |