From: blackw@sfu.ca
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] odbc V3+
Date: Wed, 01 Sep 1999 20:32:37 GMT
Message-ID: <199909012032.NAA14480@rm-rstar.sfu.ca> (raw)
Paul wrote:
> Any scuttle butt on when the Postgresql odbc will move from 2 to 3?
To which Byron replied:
> Not very likely. [SNIP-O-RAMA] The driver
> should still work with odbc 3.0 applications because the odbc driver
> manager is supposed to convert calls to odbc 2.x on the fly. I'm not
> sure how extensively it does this.
I'd like to know where you came across this information, as I have not been able to confirm anywhere that a driver manager will perform the conversion you suggest. Quite to the contrary, I have found the following statement in Microsoft documentation:
"Applications that follow the ODBC 3.x specification must use conditional code to avoid using functionality new to ODBC 3.x when working with ODBC 2.x drivers. ODBC 2.x drivers do not support functionality new to ODBC 3.x just because the application declares that it follows the ODBC 3.x specification."
(MSDN Library - April 1999/
Platform SDK/
Data Access Services/
Microsoft Data Access 2.1 SDK/
Microsoft Open Database Connectivity (ODBC)/
Part 2 Developing Applications and Drivers/
Chapeter 6: Connecting to a Data Source or Driver/
Page: Delcaring the Application's ODBC Version
)
So, if you have a resource that indicates the contrary, I'd sure like to get my hands on it. Thanks.
Cheers,
Richard Blackwell
Programmer/Analyst
Dept. of Psychology, Simon Fraser University
Burnaby, BC Canada
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: blackw@sfu.ca
Subject: Re: [INTERFACES] odbc V3+
In-Reply-To: <199909012032.NAA14480@rm-rstar.sfu.ca>
* 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