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