Skip site navigation (1) Skip section navigation (2)

Re: Troubleshoot "unexpected EOF on client connection"

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Troubleshoot "unexpected EOF on client connection"
Date: 2004-04-01 21:59:06
Message-ID: 20040401215906.9045.qmail@web13804.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> On Thursday 01 April 2004 20:10, Chris Gamache wrote:
> If you can't log at the client, I don't think there's much you can do to 
> diagnose this. I'd be tempted to move some stuff out of C: and make space for
> the logs, just while you're looking at this.

Whatabout the lack of a time index? I'm pretty quick, but the WebApplication
only fails under load, and I'm not THAT quick... So there would be no other way
to find the failure except for a timeindex, yes? I've seen it fail on many
different queries. I believe that they are all Select queries, though... No
Insert, Update, or Deletes... 

If its not a bug, it is probably as simple as an improper setting. Here's my
connection string in case someone sees a glaring error...

Provider=MSDASQL.1;Password=XXX;Persist Security Info=True;User
ID=XXX;Mode=ReadWrite;Extended
Properties="DRIVER={PostgreSQL};DATABASE=XXX;SERVER=XXX.XXX.XXX.XXX;PORT=5432;UID=XXX;PWD=XXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS="

Am I missing a critical setting for 7.03.01.00 ?

CG

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/

In response to

pgsql-odbc by date

Next:From: Frank FinnerDate: 2004-04-03 16:55:56
Subject: wxWidgets and PostgreSQL
Previous:From: scott.marloweDate: 2004-04-01 20:57:44
Subject: Re: stored procedures with parameters w/dotnet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group