I'm sorry, but I don't understand the examples in pg_hba.conf file.
The file contains only these non-commented lines:
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 0.0.0.0 0.0.0.0 password
When I change password to crypt or ident, then error message in Access
changes accordingly.
When I change the last line to:
host all xxx.xxx.xxx.xxx 255.255.255.255 trust
Where xxx.xxx.xxx.xxx is client's dynamically assigned IP address, I was
able to connect with Access, but pgAdmin still produced the same message
mentioned below in my first message.
Changing the last line to
host all xxx.xxx.xxx.xxx 255.255.255.255 password
gives the password authentication error in Access. In ODBC (on Win98
client side), I have username and password of the user that owns the
database I'm trying to access. Did I need to mention that the server is
running on OpenBSD?
Frank
At 12:03 AM 4/02/00 +0300, you wrote:
>Frank Bax wrote:
>>
>> Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0
>> I hope I installed all the components (for a Win98) install correctly.
>> The pg database is on a remote server, accessed across the internet.
>> I am new to this ODBC stuff, but the past few months have been using
>> psql and php3 interfaces (both local access) to 6.5.3 database.
>>
>> Anyway, I created a datasource in ODBC, but when I try to use it with
>> pgAdmin (either version), I get:
>> Error 3706, ADO could not find the specified provider.
>> function: frmODBClogon, cmdOK_Click.
>>
>> If I try to link to the same source with Access'97; I get this:
>> ODBC--call failed.
>> IDENT authentication failed for user 'gwacl' (#210).
>>
>> Are these both the same problem?
>
>probably.
>
>have you configured access from your client in pg_hba.conf to something
>like password (or possibly crypt). I doubt you have identd running on
>your ODBC client machine.
>
>-----------------
>Hannu
>
>
