From: Byron Nikolaidis <byronn@insightdist.com>
To: Steve Pratt <steve.sheliak@virgin.net>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC Error
Date: Wed, 22 Jul 1998 17:44:20 -0400
Message-ID: <35B65D34.30C71D23@insightdist.com> (raw)
References: <001501bdb5b5$1a1a9660$7045a8c2@sheldos.holme>
Steve Pratt wrote:
>
> I have installed PsqlODBC on a Win95 PC. On my Linux box there is a db
> called mydb, owner steve.
> The plan is to make use of Topspeed Clarion application generator on the WIn
> pc. There is an import function in the gui to pull in the structure of an
> ODBC compliant server. But the error message is as follows:
> "ODBC file import:
> Failed to authenticate client as Postgres user 'steve' <unknown
> authentication type>: be_recvauth: unrecognized message type: 65536"
>
> I guess it won't be Postgres' fault, but has anyone seen this type of
> problem before?
> Sorry if this is too far off topic, but thanks anyway
>
> Steve
BTW, this question is directly answered in our psqlodbc faq on our web
page http://www.insightdist.com/psqlodbc.
But the short of it is, you have a protocol mismatch between your
backend and the odbc driver.
Most likely, you have postgres 6.2 on the backend and the odbc driver is
speaking in 6.3 protocol.
If you are using the correct driver (something like version 6.30.0247),
then try setting the "6.2 protocol" setting on the Advanced Datasource
options for your datasource.
If you are using an ancient driver (postODBC), then upgrade to the one
on our website.
Byron
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: byronn@insightdist.com, steve.sheliak@virgin.net
Subject: Re: [INTERFACES] ODBC Error
In-Reply-To: <35B65D34.30C71D23@insightdist.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