Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Problem with ODBC

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Michael Doyle <relyod(at)co-operation-ireland(dot)ie>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] Problem with ODBC
Date: 1999-02-24 23:16:26
Message-ID: Pine.LNX.4.04.9902242314310.1260-100000@maidast.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Wed, 24 Feb 1999, Michael Doyle wrote:

> I have just set up Postgress on a FreeBSD server,
> and when I try to access a test table via ODBC (from Access 95)
> I see the table definition fine (it does allow me to link to it)
> but when I try to view the data in the table I get the following
> error:
> 
> 	"ERROR: test1: Permission denied. (#1)"
> 
> Any ideas as to what is wrong
> 
> Specifically I HAVE listed this PC in the pg_hba.conf, with the following
> listing:
> 
> host    all     xxx.xxx.xxx.xxx   0.0.0.0             trust
> 
> where xxx.xxx.xxx.xxx is my ip.
> I have even tried replacing the net-mask with 255.255.0.0 (the net mask on the
> lan) and that does not help

The netmask isnt the same as the lan's but that to access the PC. So if
you are allowing just the pc access then you would use something like:

host all 192.168.4.3 255.255.255.255 trust

However, for your subnet, then it would be the same as your
network's subnect, something like:

host all 192.168.4.0 255.255.255.0 trust

Peter

-- 
       Peter T Mount peter(at)retep(dot)org(dot)uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf


In response to

pgsql-interfaces by date

Next:From: Gerald L. GayDate: 1999-02-25 01:00:09
Subject: libpq and SPI
Previous:From: Tobias ErikssonDate: 1999-02-24 22:15:45
Subject: SV: SV: [INTERFACES] couldn't start postmaster - couldn't allocate sharedmemory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group