pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC - invalid protocol character
5+ messages / 3 participants
[nested] [flat]
* ODBC - invalid protocol character
@ 2000-09-22 12:22 Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 0 replies; 5+ messages in thread
From: Cedar Cox @ 2000-09-22 12:22 UTC (permalink / raw)
To: pgsql-interfaces
Ok, this happened yesterday so I don't remember exactly what happened.
We're working with Access 97 and PG 7.x (how do I find my PG version?).
I think it was when attempting to do a passthrough query I got the message
"An invalid protocol character was received from the backend." I don't
think I saw anything in the backend log because I remember being a little
confused as to where the error was coming from. Anyone know what's going
on? I can track down the query and give some more specific information if
necessary.
Thanks much,
-Cedar
^ permalink raw reply [nested|flat] 5+ messages in thread
* ODBC - Invalid protocol character
@ 2001-01-03 13:51 Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 1 reply; 5+ messages in thread
From: Cedar Cox @ 2001-01-03 13:51 UTC (permalink / raw)
To: pgsql-interfaces
When using the odbc driver from Access in Win9x we sometimes receive the
error message "An invalid protocol character was received from the
backend". While this could mean that someone passed gas, I don't think
so. Anyone see this before? The one particular query that gave this
error is:
SELECT Description AS "Item", SuitabilityName AS "Suitability",
AgeGroupName AS "Age Group", SizeName AS "Size", Qty AS "Quantity",
tblStResTree_cache.SurID
FROM tblListRequestItems, tblIdSuitability, tblIdAgeGroup, tblIdSize,
tblStResTree_cache
WHERE tblListRequestItems.SuitabilityID = tblIdSuitability.SuitabilityID
AND tblListRequestItems.AgeGroupID = tblIdAgeGroup.AgeGroupID
AND tblListRequestItems.SizeID = tblIdSize.SizeID
AND tblListRequestItems.TreeID = tblStResTree_cache.TreeID
AND RequestItemID=3;
It really doesn't look strange at all, so I'm not sure what's wrong.
This happened a while ago and things have changed since then so I'm not
sure if I can reproduce the error or not. If needed I can dig through my
archive in a little and try to give a stable test case for this problem.
-Cedar
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: ODBC - Invalid protocol character
@ 2001-01-03 16:12 Michael Davis <mdavis@sevainc.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Davis @ 2001-01-03 16:12 UTC (permalink / raw)
To: 'Cedar Cox' <cedarc@visionforisrael.com>; pgsql-interfaces
Does this query work in psql? Can we see the psqlodbc_????.log file from your C: drive?
-----Original Message-----
From: Cedar Cox [SMTP:cedarc@visionforisrael.com]
Sent: Wednesday, January 03, 2001 6:51 AM
To: pgsql-interfaces@postgresql.org
Subject: ODBC - Invalid protocol character
When using the odbc driver from Access in Win9x we sometimes receive the
error message "An invalid protocol character was received from the
backend". While this could mean that someone passed gas, I don't think
so. Anyone see this before? The one particular query that gave this
error is:
SELECT Description AS "Item", SuitabilityName AS "Suitability",
AgeGroupName AS "Age Group", SizeName AS "Size", Qty AS "Quantity",
tblStResTree_cache.SurID
FROM tblListRequestItems, tblIdSuitability, tblIdAgeGroup, tblIdSize,
tblStResTree_cache
WHERE tblListRequestItems.SuitabilityID = tblIdSuitability.SuitabilityID
AND tblListRequestItems.AgeGroupID = tblIdAgeGroup.AgeGroupID
AND tblListRequestItems.SizeID = tblIdSize.SizeID
AND tblListRequestItems.TreeID = tblStResTree_cache.TreeID
AND RequestItemID=3;
It really doesn't look strange at all, so I'm not sure what's wrong.
This happened a while ago and things have changed since then so I'm not
sure if I can reproduce the error or not. If needed I can dig through my
archive in a little and try to give a stable test case for this problem.
-Cedar
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC - Invalid protocol character
@ 2001-01-03 16:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2001-01-03 16:45 UTC (permalink / raw)
To: Cedar Cox <cedarc@visionforisrael.com>; +Cc: pgsql-interfaces
Cedar Cox <cedarc@visionforisrael.com> writes:
> When using the odbc driver from Access in Win9x we sometimes receive the
> error message "An invalid protocol character was received from the
> backend". While this could mean that someone passed gas, I don't think
> so. Anyone see this before?
That suggests that the frontend and backend got out of sync. There used
to be some bugs that could cause that, but I thought we'd fixed 'em all.
What Postgres version are you running?
If you're on 7.0 or later, I'd definitely like to see a reproducible
test case...
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC - Invalid protocol character
@ 2001-01-03 20:00 Cedar Cox <cedarc@visionforisrael.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Cedar Cox @ 2001-01-03 20:00 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-interfaces
On Wed, 3 Jan 2001, Tom Lane wrote:
> Cedar Cox <cedarc@visionforisrael.com> writes:
> > When using the odbc driver from Access in Win9x we sometimes receive the
> > error message "An invalid protocol character was received from the
> > backend". While this could mean that someone passed gas, I don't think
> > so. Anyone see this before?
>
> That suggests that the frontend and backend got out of sync. There used
> to be some bugs that could cause that, but I thought we'd fixed 'em all.
> What Postgres version are you running?
>
> If you're on 7.0 or later, I'd definitely like to see a reproducible
> test case...
I'm on PG 7.0.2 and using the ODBC driver I grabbed from the "main ODBC
site" back in July. I've got lots of (maybe too many ;) backups of our
development. I'll see what I can come up with.
--
On Wed, 3 Jan 2001, Michael Davis wrote:
> Does this query work in psql? Can we see the psqlodbc_????.log file
> from your C: drive?
Again, this happened a while ago. I'm sure the query would have worked
from psql.. there's nothing strange about it. I have to enable logging in
the PG ODBC driver to get a psqlodbc_????.log, right? Will this log
errors like this one?
-Cedar
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-01-03 20:00 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-22 12:22 ODBC - invalid protocol character Cedar Cox <cedarc@visionforisrael.com>
2001-01-03 13:51 ODBC - Invalid protocol character Cedar Cox <cedarc@visionforisrael.com>
2001-01-03 16:45 ` Re: ODBC - Invalid protocol character Tom Lane <tgl@sss.pgh.pa.us>
2001-01-03 20:00 ` Re: ODBC - Invalid protocol character Cedar Cox <cedarc@visionforisrael.com>
2001-01-03 16:12 RE: ODBC - Invalid protocol character Michael Davis <mdavis@sevainc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox