Thread: Error

I got error when I try export data from MS SQL server to PostgreSQL 8.1 but MS SQL("192.192.0.x") and PostgreSQL("192.192.0.y") install difference server.

Error Source : Microsoft OLE DB Provider for ODBC Drivers
Error Description: Fatal: no pg_hba.conf entry for host "192.192.0.x", user "timesheet", database "timesheet", SSL off

I think error come from ODBC connect to PostgresQL

Pleas advise
Phinhathai

> I got error when I try export data from MS SQL server to PostgreSQL
> 8.1 but MS SQL("192.192.0.x") and PostgreSQL("192.192.0.y") install
> difference server.
>
> Error Source : Microsoft OLE DB Provider for ODBC Drivers
> Error Description: Fatal: no pg_hba.conf entry for host "192.192.0.x",
> user "timesheet", database "timesheet", SSL off

Please follow the error message and define the access for user timesheet
to database timesheet from 192.192.0.x in pg_hba.conf in your
PostgreSQL backend (you could find it in PgSQL documentation).

Regards,

Luf