Message-ID: <39D5666E.BA811D6C@aajs.com>
Date: Fri, 29 Sep 2000 21:05:02 -0700
From: "Aage J. Skjolingstad" <aages@aajs.com>
Organization: Ship Net International
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: ODBC with version 7.0.2
References: <Pine.LNX.4.10.10009291231000.9040-100000@altoplanos.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Had same problem. Give access in .conf to the IP address(es) on your
Windows client(s) and it will work.

I'm running PostreSQL sever on Linux and using both a web server with
Linux w/ unixODBC driver and Win98 on production machine using the
PostgreSQL windows ODBC driver.

Good Luck,

Aage

"Roderick A. Anderson" wrote:
> 
> On Fri, 29 Sep 2000, James Orr wrote:
> 
> > Is it possible to get an ODBC connection from windows to postgresql 7.0.2
> > on linux?
> 
> I've done it on both Windows 95 and NT systems.  The gotcha from me was
> granting access to PostgreSQL to hosts other than the localhost.  Check
> out your pg_hba.conf file.
> 
> > I don't seem to be having any luck with the ODBC drivers on the
> > postgres website, and they only seem to mention up to 6.5 in the
> > settings.
> 
> This is the driver I've used.
> 
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814