From: Frank Joerdens <frank@joerdens.de>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: confused about *nix ODBC drivers
Date: Tue, 31 Oct 2000 11:38:05 +0100
Message-ID: <20001031113805.A1752@rakete.joerdens.de> (raw)
In-Reply-To: <Pine.LNX.4.21.0010311059290.2966-100000@nanu.visionforisrael.com>
References: <39FD9429.A07D2C62@joerdens.de>
<Pine.LNX.4.21.0010311059290.2966-100000@nanu.visionforisrael.com>
On Tue, Oct 31, 2000 at 11:01:51AM +0200, Cedar Cox wrote:
>
> > Currently I am trying to get unixODBC to work, where the
> > /usr/local/etc/odbc.ini files looks like:
> >
> > [PostgreSQL]
> > Description = Test to Postgres
> > Driver = PostgreSQL
> > Trace = Yes
> > TraceFile = sql.log (what's the absolute path? the user's
> > home dir? I don't find an sql.log file anyhwere.)
> > Database = intranet
> > Servername = localhost
> > UserName =
> > Password =
> > Port = 5432
> > Protocol = 7.1
> > ReadOnly = No
> > RowVersioning = No
> > ShowSystemTables = No
> > ShowOidColumn = No
> > FakeOidIndex = No
> > ConnSettings =
>
> Which version of PG are you using? Is there a new 7.1 protocol?
I am using the 7.1 current snapshot version and I don´t know which
protocol it uses. I´ll try 6.5. Incidentally, I tried to access my 7.1
installation via the Insight Win32 ODBC driver (latest version from
ftp.de.postgresql.org/odbc) - which I verified to
be working correctly with another (6.5) installation - without success.
I was going to post this issue separately in order not to confuse
the unixODBC issue with the Win32 issue. But then again, they may be
related.
With the Win32 driver I do get a connection from MS Access to the 7.1
database, but I don´t see any tables (with the 6.5 database I do). From
what I can gather from the log file (can´t include it now cuz it´s on
another box in another office), the query to show tables is sent to the
backend, but no rows are found. I get the same effect when cutting and
pasting the query from the log file to a console to a psql prompt: On
6.5, rows are returned, on 7.1, there aren´t. Which leads me to conclude
that something was indeed changed in 7.1 vis-a-vis the odbc interface.
The source tree for the 7.1 snapshot contains an
src/interfaces/odbc/odbc.sql file containing "PostgreSQL catalog
extensions for ODBC compliance" which I did run against my 7.1 installation.
Maybe this has something to do with. I don´t know whether these catalog
extension where part of the 6.5 distro, because I don´t have a 6.5
source tree at hand.
What I´ll try next is to get 6.5 to work with unixODBC to see whether
it´s some issue with a new 7.1 interface.
Regards,
Frank
--
frank joerdens
joerdens new media
urbanstr. 116
10967 berlin
germany
e: frank@joerdens.de
t: +49 (0)30 69597650
f: +49 (0)30 7864046
h: http://www.joerdens.de
pgp public key: http://www.joerdens.de/pgp/frank_joerdens.asc
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: frank@joerdens.de, cedarc@visionforisrael.com
Subject: Re: confused about *nix ODBC drivers
In-Reply-To: <20001031113805.A1752@rakete.joerdens.de>
* 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