pgsql-odbc

This is my code which I have included to connect to postgresql in SUSE
linux from windows machine.

Dim MyDB As New ADODB.Connection
Dim Rc As New ADODB.Recordset
Private Sub Command1_Click()

With MyDB
  .CursorLocation = adUseClient
  .Open "Provider='PostgreSQL';Database='test';host='10.1.2.86';"

End With

End Sub

I am getting the following error:
"Could not connect to server:connection refused(0x0000274D/10061) is the
server running on the host"" and accepting TCP/IP on port 5432"

I  have modified pg_hba.conf  on the linux server to allow connections
froms other hosts also.
Just dont know what to do??

Minal