Received: from liffey.co-operation-ireland.ie (d1-ppp-131.connect.ie [194.106.128.131]) by hub.org (8.9.2/8.9.1) with ESMTP id GAA27404 for ; Wed, 24 Feb 1999 06:47:08 -0500 (EST) (envelope-from relyod@co-operation-ireland.ie) Received: from it1 (it1 [199.107.2.129]) by liffey.co-operation-ireland.ie (8.8.8/8.8.8) with SMTP id LAA19615 for ; Wed, 24 Feb 1999 11:43:23 GMT (envelope-from relyod@co-operation-ireland.ie) Message-Id: <3.0.5.32.19990224114455.007e6ac0@199.107.2.1> X-Sender: relyod@199.107.2.1 X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Wed, 24 Feb 1999 11:44:55 +0000 To: pgsql-interfaces@postgreSQL.org From: Michael Doyle Subject: Problem with ODBC Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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 *********************************************************************