Skip site navigation (1) Skip section navigation (2)

Re: Connecting to PGSQL

From: mlw <developer(at)mohawksoft(dot)com>
To: Vikram Sulakhe <sulak001(at)bama(dot)ua(dot)edu>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connecting to PGSQL
Date: 2002-09-03 13:37:12
Message-ID: 3D74BB08.866F8378@mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Vikram Sulakhe wrote:
> 
> I am using CRecordset object to access the pgSQL database. While I insert
> this CRecordset Object using class wizard in Visual Studio I get following
> error
> "FATAL 1: No pg_hba.conf entry for host 130.160.161.142, user grade,
> database oscar"
> 
> ODBC driver version: 07.02.0002
> PostgreSQL database version : 7.2.1
> error message: FATAL 1: No pg_hba.conf entry for host 130.160.161.142, user
> grade, database oscar
> the commlog(psqlodbc_????.log) file (you will have to enable the commlog
> driver option) : attached
> the ODBC trace log (sql.log) file (if the problem warrants it) : attached
> 
> looking forward to your reply,
> 
> Regards,
> Vikram

That looks easy, check the pg_hba.conf file on your PostgreSQL server. It is
not configured to allow your IP address.


> 
>   -------------------------------------------------------------------------------
>                         Name: psqlodbc_3616.log
>    psqlodbc_3616.log    Type: unspecified type (application/octet-stream)
>                     Encoding: quoted-printable
> 
>               Name: SQL.LOG
>    SQL.LOG    Type: unspecified type (application/octet-stream)
>           Encoding: quoted-printable
> 
>   -------------------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

pgsql-odbc by date

Next:From: Lázaro Alonso Baca MarínDate: 2002-09-03 16:16:11
Subject: suscribe
Previous:From: Vikram SulakheDate: 2002-09-03 06:07:14
Subject: Connecting to PGSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group