Re: Connecting to PGSQL

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@postgresql.org so that your
> message can get through to the mailing list cleanly