I can not access to postgresql server 9.1.3 form client computer with front-end application written in MS Visual Foxpro 9 SP2.
Application made connection when work on PC where is postgresql server installed.
Connstr="DRIVER={PostgreSQL odbc driver(unicode)};server=localhost;Port=5432;Database=mydatabase; Uid=postgres;Pwd=mypwd;UseServerSidePrepare=1;MaxVarcharSize=254;UnknownsAsLongVarchar=0;TextAsLongVarchar=0;"
I installed ODBC driver v 09.00.0310-1 on client PC. Also firewall is disabled on server side.
This a settings in postgresql.conf file:
listen_addresses = '*'
This a settings in pg_hba.conf file:
# IPv4 local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::0/0 md5
I got this message:
Connectivity error: Could not connect to server;
No connection could be made because the target machine actively refused it (127.0.0.1:5432)
Any ideas what is wrong ?.
Thank’s
Ilija