Error

Error

am 27.12.2006 04:54:30 von phinhathai

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7296A.B66EED86
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01C7296A.B66EED86
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




charset=3Diso-8859-1">
6.5.7226.0">
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






------_=_NextPart_001_01C7296A.B66EED86--

Re: Error

am 02.01.2007 17:47:56 von Ludek Finstrle

> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org