From: Michael Davis <mdavis@sevainc.com>
To: 'Cedar Cox' <cedarc@visionforisrael.com>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: RE: ODBC - Invalid protocol character
Date: Wed, 3 Jan 2001 09:12:14 -0700
Message-ID: <01C07565.452D3070.mdavis@sevainc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mdavis@sevainc.com, cedarc@visionforisrael.com
Subject: RE: ODBC - Invalid protocol character
In-Reply-To: <01C07565.452D3070.mdavis@sevainc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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