pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedCoppatibility of ODBC drivers with forecoming 7.1
5+ messages / 4 participants
[nested] [flat]
* Coppatibility of ODBC drivers with forecoming 7.1
@ 2000-12-16 08:29 Emmanuel Charpentier,,, <charpent@bacbuc.dyndns.org>
0 siblings, 1 reply; 5+ messages in thread
From: Emmanuel Charpentier,,, @ 2000-12-16 08:29 UTC (permalink / raw)
To: pgsql-interfaces
Dear List,
It seems that PosgreSQL 7.1, which is in beta and seems to be close the
out door, will bring us, among other things, the much awaited outer joins.
I wonder if a new ODBC driver will be necessary to be able to use this
feature, or if the current (6.50.0, IIRC) will be able to use it more or
less "automagically".
Any thoughts ?
Emmanuel Charpentier
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Coppatibility of ODBC drivers with forecoming 7.1
@ 2000-12-18 22:03 Joel Burton <jburton@scw.org>
parent: Emmanuel Charpentier,,, <charpent@bacbuc.dyndns.org>
0 siblings, 0 replies; 5+ messages in thread
From: Joel Burton @ 2000-12-18 22:03 UTC (permalink / raw)
To: Emmanuel Charpentier,,, <charpent@bacbuc.dyndns.org>; +Cc: pgsql-interfaces
On 16 Dec 2000, at 9:29, Emmanuel Charpentier,,, wrote:
> It seems that PosgreSQL 7.1, which is in beta and seems to be close
> the out door, will bring us, among other things, the much awaited
> outer joins.
>
> I wonder if a new ODBC driver will be necessary to be able to use this
> feature, or if the current (6.50.0, IIRC) will be able to use it more
> or less "automagically".
I've been using 7.1devel for a few months w/ODBC (mostly Access,
some VB), and it works fine for outer joins.
It does not however work well with the stock ODBC driver, which
shows no tables. You should compile the driver from CVS sources.
(This also fixes the referential-integrity-error problem).
More information & a precompiled driver at www.scw.org/pgaccess
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Coppatibility of ODBC drivers with forecoming 7. 1
@ 2000-12-19 08:40 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Dave Page @ 2000-12-19 08:40 UTC (permalink / raw)
To: 'Joel Burton' <jburton@scw.org>; +Cc: pgsql-interfaces
> -----Original Message-----
> From: Joel Burton [mailto:jburton@scw.org]
> Sent: 18 December 2000 22:03
> To: Emmanuel Charpentier,,,
> Cc: Pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] Coppatibility of ODBC drivers with
> forecoming
> 7.1
>
>
> More information & a precompiled driver at www.scw.org/pgaccess
Hi Joel,
Just downloaded this driver to get the referential integrity stuff and find
that the version number is 6.40.0.9 whereas the latest version that Byron (I
assume it was Byron anyway) compiled was 6.50.0.0. Is your version based on
older code or is there another reason for this?
Regards,
Dave.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Coppatibility of ODBC drivers with forecoming 7.1
@ 2000-12-19 17:47 Joel Burton <joel@scw.org>
0 siblings, 0 replies; 5+ messages in thread
From: Joel Burton @ 2000-12-19 17:47 UTC (permalink / raw)
To: Emmanuel Charpentier,,, <charpent@bacbuc.dyndns.org>; +Cc: pgsql-interfaces
On Tue, 19 Dec 2000, Emmanuel Charpentier,,, wrote:
> >> It seems that PosgreSQL 7.1, which is in beta and seems to be close
> >> the out door, will bring us, among other things, the much awaited
> >> outer joins.
> >>
> >> I wonder if a new ODBC driver will be necessary to be able to use this
> >> feature, or if the current (6.50.0, IIRC) will be able to use it more
> >> or less "automagically".
> >
> > I've been using 7.1devel for a few months w/ODBC (mostly Access,
> > some VB), and it works fine for outer joins.
>
>
> You mean that you use it mostly from Windows, right ?
Yes. I have fairly little experience w/Linux/Unix as an ODBC client.
> I was thinnking about uses from other Unix programs. While a bit
less
> efficient than direct use of PostgreSQL libraries on the same machine,
> use of ODBC as a standard access method to data makes life a *lot*
> easier when you have to port to other machines and/or other platforms.
Yes, for those Unix/Linux programs that use ODBC well. I find StarOffice
a bit flakey, for instance.
Most of the Unix/Linux work we do is wrapped up in things like
Perl's DBD module, so it has a different kind of wrapper, but, of
course, that's programming, not application use.
> > More information & a precompiled driver at www.scw.org/pgaccess
>
>
> I've seen this. May I suggest to put the FAQ in (even rough) HTML format
> ? The lines you typed having no formatting, one has to continuouslu
> scroll across the screen to read the text. EPITA ...
There is (& has been) an HTML version there. It's not pretty,
but no scrolling involved.
Good luck,
JB
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Coppatibility of ODBC drivers with forecoming 7. 1
@ 2000-12-19 17:50 Joel Burton <joel@scw.org>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Joel Burton @ 2000-12-19 17:50 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: pgsql-interfaces
On Tue, 19 Dec 2000, Dave Page wrote:
> > More information & a precompiled driver at www.scw.org/pgaccess
>
> Just downloaded this driver to get the referential integrity stuff and find
> that the version number is 6.40.0.9 whereas the latest version that Byron (I
> assume it was Byron anyway) compiled was 6.50.0.0. Is your version based on
> older code or is there another reason for this?
AFAIK, that is the most up-to-date. I compiled it about 2-3 weeks
ago; there have been a few (tiny) patches to the CVS code since, and I'll
probably update that in a week or two to include those.
But, yes, the version numbers seem somewhat broken. I made no attempt to
find/fix the version numbers; this may or may not have been fixed in the
latest CVS.
BTW, pgAdmin looks better the ever. Keep up the good work!
JB
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2000-12-19 17:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-16 08:29 Coppatibility of ODBC drivers with forecoming 7.1 Emmanuel Charpentier,,, <charpent@bacbuc.dyndns.org>
2000-12-18 22:03 ` Joel Burton <jburton@scw.org>
2000-12-19 08:40 RE: Coppatibility of ODBC drivers with forecoming 7. 1 Dave Page <dpage@vale-housing.co.uk>
2000-12-19 17:50 ` RE: Coppatibility of ODBC drivers with forecoming 7. 1 Joel Burton <joel@scw.org>
2000-12-19 17:47 Re: Coppatibility of ODBC drivers with forecoming 7.1 Joel Burton <joel@scw.org>
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