From: Michael Meskes <meskes@postgresql.org>
To: Frank Jördens <frank@joerdens.de>
Cc: Maarten Boekhold <Maarten.Boekhold@reuters.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: confused about *nix ODBC drivers
Date: Tue, 31 Oct 2000 12:03:35 +0100
Message-ID: <20001031120335.A4734@feivel.credativ.de> (raw)
In-Reply-To: <39FD9429.A07D2C62@joerdens.de>
References: <200010301154.MAA29984@rakete.joerdens.de>
<39FD9429.A07D2C62@joerdens.de>
On Mon, Oct 30, 2000 at 04:30:49PM +0100, Frank Jördens wrote:
> Currently I am trying to get unixODBC to work, where the
Do you use the graphical frontend to configure it? Should check for some
misconfigurations.
> /usr/local/etc/odbc.ini files looks like:
>
> [PostgreSQL]
> Description = Test to Postgres
...
> TraceFile = sql.log (what's the absolute path? the user's
> home dir? I don't find an sql.log file anyhwere.)
I'm not sure about this either. How about trying /tmp/sql.log instead?
> Protocol = 7.1
I'm running version 7.0 and it definitely needs protocol 6.4!
> and /usr/local/etc/odbcinst.ini:
>
> [PostgreSQL]
> Driver = /usr/local/pgsql/lib/libpsqlodbc.so
> FileUsage = 1
I'd recommend trying /usr/lib/libodbcpsql.so as Driver instead. I also had
problems getting unixodbc going with our own odbc driver. If you add a line
Setup = /usr/lib/libodbcpsqlS.so
the graphical setup tool will help a lot.
> I could presumably also put in the IP address of some server, which
> would satisfy my requirement - which is to have the client on a
> different box than the server.
Some connections do not work with IP numbers. Did you try a resolvable host
name?
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
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: meskes@postgresql.org, frank@joerdens.de, Maarten.Boekhold@reuters.com
Subject: Re: confused about *nix ODBC drivers
In-Reply-To: <20001031120335.A4734@feivel.credativ.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