Re: [INTERFACES] Problem with ODBC

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