Received: from feivel (cdt1.tz-juelich.de [195.37.52.66])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9VB3cl34009
	for <pgsql-interfaces@postgresql.org>;
	Tue, 31 Oct 2000 06:03:39 -0500 (EST)
	(envelope-from Michael.Meskes@credativ.de)
Received: by feivel (Postfix, from userid 1000)
	id 66A81A6118; Tue, 31 Oct 2000 12:03:36 +0100 (CET)
Date: Tue, 31 Oct 2000 12:03:35 +0100
From: Michael Meskes <meskes@postgresql.org>
To: =?iso-8859-1?Q?Frank_J=F6rdens?= <frank@joerdens.de>
Cc: Maarten Boekhold <Maarten.Boekhold@reuters.com>,
	pgsql-interfaces@postgresql.org
Subject: Re: confused about *nix ODBC drivers
Message-ID: <20001031120335.A4734@feivel.credativ.de>
Mail-Followup-To: =?iso-8859-1?Q?Frank_J=F6rdens?= <frank@joerdens.de>,
	Maarten Boekhold <Maarten.Boekhold@reuters.com>,
	pgsql-interfaces@postgresql.org
References: <200010301154.MAA29984@rakete.joerdens.de>
	<39FD9429.A07D2C62@joerdens.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.2.5i
In-Reply-To: <39FD9429.A07D2C62@joerdens.de>;
	from frank@joerdens.de on Mon, Oct 30, 2000 at 04:30:49PM +0100
X-Archive-Number: 200010/17
X-Sequence-Number: 17

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!