Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 92890476713
	for <pgsql-interfaces@postgresql.org>;
	Thu,  4 Jul 2002 05:18:03 -0400 (EDT)
Mailbox-Line: From andi@kretzer-berlin.de  Thu Jul  4 05:18:03 2002
Received: from mailout02.sul.t-online.com (mailout02.sul.t-online.com
	[194.25.134.17])
	by postgresql.org (Postfix) with ESMTP id 4C468476303
	for <pgsql-interfaces@postgresql.org>;
	Thu,  4 Jul 2002 03:55:50 -0400 (EDT)
Received: from fwd08.sul.t-online.de by mailout02.sul.t-online.com with smtp
	id 17Q1Sv-0001th-03; Thu, 04 Jul 2002 09:55:49 +0200
Received: from radove.kretzer.local (03049766176-0001@[62.155.172.244]) by
	fmrl08.sul.t-online.com
	with esmtp id 17Q1Sh-0kFW0OC; Thu, 4 Jul 2002 09:55:35 +0200
Received: from andi (andi.kretzer.local [192.168.101.1])
	by radove.kretzer.local (8.11.3/8.11.3/SuSE Linux 8.11.1-0.5) with
	ESMTP id g64A0Xr05685
	for <pgsql-interfaces@postgresql.org>; Thu, 4 Jul 2002 12:00:33 +0200
Message-ID: <200207040954320620.0012BDA0@radove.kretzer.local>
In-Reply-To: <000801c2222c$e69d9e70$e0a44542@THELIZARDKING>
References: <000801c2222c$e69d9e70$e0a44542@THELIZARDKING>
X-Mailer: Calypso Version 3.30.00.00 (3)
Date: Thu, 04 Jul 2002 09:54:32 +0200
From: "Andreas Kretzer" <andi@kretzer-berlin.de>
To: <pgsql-interfaces@postgresql.org>
Subject: Re: odbc
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-Sender: 03049766176-0001@t-dialin.net
X-Spam-Status: No, hits=2.3 required=5.0
	tests=IN_REP_TO,RATWARE,MSG_ID_ADDED_BY_MTA_3 version=2.30
X-Spam-Level: **
X-Archive-Number: 200207/9
X-Sequence-Number: 2818

>On 02.07.2002 at 19:59 Roberto Benitez wrote:
>hi, i have a postgresql db set up on a linux server
>i can access  it w/o a problem from that machine, but when i try to access
>it from odbc, i get an error
>it says it cannot find a 'pg_hda.conf' entry for [IP Address], [User],
>[Database]
>i set up the pg_hda.conf to accept a given range of IP's or tried to at
>least.
>
>what else do i need to do?

First, make sure you're using the correct pg_hba.conf in the postgres
data directory! Then restart postgres server to bring changes in effect.

Second, you will need to create a data base user using the 'createuser'
command. Use your logon name on the remote machine as the user
name to create.

If you have successfully connected to the database you still can run
into trouble if you forgot to allow access to the records in your
data base. Use 'GRANT SELECT ON <table> TO <user>' as a minimum
access-level.

If you have no success with that, please post your pg_hba.conf and
the concrete values for "[IP Adress], ..." from above. And specify your
odbc client machine (just guessing: Windows, Access ???)

Regards
Andreas