ODBC <6.4 protocol

Started by Bruce Momjianalmost 25 years ago3 messages

pgman@candle.pha.pa.us

almost 25 years ago

I have backed out the changes to ODBC that removed compatibility with
<6.4 servers, so the 7.1 ODBC code still supports the older servers.
I have changed the dialog box from "6.4+" to "7.X,6.4+" to make it less
confusing for users.

Is that ODBC protocol dialog box needed? Can the client auto-detect the
server version?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Dave Page

dpage@vale-housing.co.uk

almost 25 years ago

In reply to: Bruce Momjian (#1)

RE: [ODBC] ODBC <6.4 protocol

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: 14 February 2001 06:20
To: PostgreSQL-development
Cc: PostgreSQL odbc list
Subject: [ODBC] ODBC <6.4 protocol

I have backed out the changes to ODBC that removed compatibility with
<6.4 servers, so the 7.1 ODBC code still supports the older servers.
I have changed the dialog box from "6.4+" to "7.X,6.4+" to
make it less
confusing for users.

Is that ODBC protocol dialog box needed? Can the client
auto-detect the
server version?

I would assume not because the driver needs to make the connection and
execute SELECT version() to figure out the server version (which is what
happens with the current driver during the ODBC connection initialisation),
unless there is a way to figure it out from the server's response when the
tcp/ip connection is initiated. I'm not familiar with the protocol used
though so I can't comment on that...

Regards,

Dave.

Import Notes

Resolved by subject fallback

Hiroshi Inoue

Inoue@tpf.co.jp

almost 25 years ago

In reply to: Dave Page (#2)

Re: [ODBC] ODBC <6.4 protocol

Dave Page wrote:

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]

I have backed out the changes to ODBC that removed compatibility with
<6.4 servers, so the 7.1 ODBC code still supports the older servers.
I have changed the dialog box from "6.4+" to "7.X,6.4+" to
make it less
confusing for users.

Is that ODBC protocol dialog box needed? Can the client
auto-detect the
server version?

I would assume not because the driver needs to make the connection and
execute SELECT version() to figure out the server version (which is what
happens with the current driver during the ODBC connection initialisation),

version() first appeared in 6.4.

Regards,
Hiroshi Inoue