Thread: Re: [INTERFACES] Problem with ODBC

Re: [INTERFACES] Problem with ODBC

From
"David Hartwig"
Date:
It looks like the user established in your data source (DSN) does not have
select permission on the table you are trying to browse.   You need to
either GRANT permission to the user or change the user in the DSN.

----- Original Message -----
From: Peter T Mount <peter@retep.org.uk>
To: Michael Doyle <relyod@co-operation-ireland.ie>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Wednesday, February 24, 1999 6:16 PM
Subject: 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@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
>
>
>