Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35DA37A8.2D0F1482@alumni.caltech.edu>
Date: Wed, 19 Aug 1998 02:25:44 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Byron Nikolaidis <byronn@insightdist.com>, Tom Lane <tgl@sss.pgh.pa.us>
CC: Postgres Interfaces Mailing List <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] iodbc interface on Unix
References: <35D99896.DFB21123@alumni.caltech.edu>
	<35D9D132.4DE6ACB8@insightdist.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> Yes, if you are using a snapshot of 6.4 then the driver won't work 
> because it is using 6.3 protocol.  And it uses PG_PROTOCOL_LATEST
> in its connect for the protocol version.  Maybe it should use 6.3.

Ah. That sounds like the problem.

> How do you set the protocol version to be 6.3?  Is it just major 
> number = 6 and minor number = 3?  Seems too simple.

It's even simpler. The protocol started at 0.0, was 1.0 for v6.3, and
will be 2.0 for v6.4. But on the surface it looks like we are OK for
now, unless Postgres doesn't really like v6.3 packets:

/opt/postgres/current/src/interfaces/odbc.new/connection.h:
  #define PG_PROTOCOL_LATEST              PG_PROTOCOL(1, 0)
/opt/postgres/current/src/interfaces/odbc.new/connection.c:
  sp.protoVersion = (ProtocolVersion) htonl(PG_PROTOCOL_LATEST);

> Also, as far as compiling goes, I understand the driver has trouble 
> compiling under Linux since the Translation DLL stuff was
> added.  Did you have to ifdef that stuff out for Non-win32?

Yeah, it didn't help :) I hope to get somewhere on this soon, and I can
send patches or full sources which include changes. No point in making
you guess on what actually worked...

So, any more ideas/suggestions on how to get this working?

                    - Tom