Обсуждение: Problem with ODBC

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 user I'm giving as a user name to ODBC can view/modify the data when
logged in to the FreeBSD server.

Any ideas ?

<>< ============================================================ ><>
Michael Doyle                    email: relyod@co-operation-ireland.ie
Network Administrator            personal email:    relyod@indigo.ie
Co-operation Ireland      http://www.co-operation-ireland.ie/
Phone: +353-1-661 0588                          Fax: +353-1-661 8456

*********************************************************************

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@retep.org.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