PgODBC's logfiles don't have a time index, and you also can't change the output
location of the files unless you recompile the driver (unless you know
something that I don't). My C drive is strictly OS, and there's not much
breathing room there. I can't get PgODBC to build under VisualStudio.NET, so a
recompile to include timestamp and variable logfile location is out of my
ability. I don't know why, but I can not get a trace from the ODBC control
panel either. Can you help?
CG
--- Richard Huxton <dev@archonet.com> wrote:
> On Wednesday 31 March 2004 15:24, Chris Gamache wrote:
> > Some of my ODBC connections are dying unexpectedly (and randomly) with the
> > Postgresql Log Message "unexpected EOF on client connection" ... It happens
> > about one in every 50K-100K queries.
>
> This is commonly the client crashing / timing out.
>
> > I would really appreciate some suggestions for a method to find the cause
> > of these dropped connections.
>
> You could turn logging on at the client end - there are settings in the odbc
> driver settings. Could be a big log-file though, if you have to wait 100,000
> queries.
>
> --
> Richard Huxton
> Archonet Ltd
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/