pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem with ODBC
3+ messages / 3 participants
[nested] [flat]
* Problem with ODBC
@ 1999-02-24 11:44 Michael Doyle <relyod@co-operation-ireland.ie>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Doyle @ 1999-02-24 11:44 UTC (permalink / raw)
To: pgsql-interfaces
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
*********************************************************************
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Problem with ODBC
@ 1999-02-24 23:16 Peter T Mount <peter@retep.org.uk>
parent: Michael Doyle <relyod@co-operation-ireland.ie>
0 siblings, 0 replies; 3+ messages in thread
From: Peter T Mount @ 1999-02-24 23:16 UTC (permalink / raw)
To: Michael Doyle <relyod@co-operation-ireland.ie>; +Cc: 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@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Problem with ODBC
@ 1999-02-25 01:54 David Hartwig <daybee@bellatlantic.net>
0 siblings, 0 replies; 3+ messages in thread
From: David Hartwig @ 1999-02-25 01:54 UTC (permalink / raw)
To: Peter T Mount <peter@retep.org.uk>; Michael Doyle <relyod@co-operation-ireland.ie>; +Cc: pgsql-interfaces
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
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-02-25 01:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-24 11:44 Problem with ODBC Michael Doyle <relyod@co-operation-ireland.ie>
1999-02-24 23:16 ` Peter T Mount <peter@retep.org.uk>
1999-02-25 01:54 Re: [INTERFACES] Problem with ODBC David Hartwig <daybee@bellatlantic.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox