From: Carlos Amaral <camaral@isnet.com.br>
To: pgsql-interfaces@postgresql.org
Subject: Re: odbc
Date: Thu, 04 Jul 2002 08:02:05 -0300
Message-ID: <3D242B2D.2080000@isnet.com.br> (raw)
References: <000801c2222c$e69d9e70$e0a44542@THELIZARDKING>
<200207040954320620.0012BDA0@radove.kretzer.local>
Please, can anybody help too ???
I've installed Postgres 7.2.1 from RedHat 7.3 and received the same
error message below.
I have pg_hba.conf in '/usr/share/pgsql/data" and "var/lib/pgsql/data",
but this message persists !!!
I'm not using odbc !! I use zeos (a connect tool for Delphi) !!! It
allways work fine, but with 7.2.1 not !!! thanks
Andreas Kretzer wrote:
>>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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: camaral@isnet.com.br
Subject: Re: odbc
In-Reply-To: <3D242B2D.2080000@isnet.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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