remote connection problem
От | Ilija Vidoevski |
---|---|
Тема | remote connection problem |
Дата | |
Msg-id | 32F0B952C0CD40B480719F3326DD3B11@fructal.com.mk обсуждение исходный текст |
Ответы |
Re: remote connection problem
Re: remote connection problem Re: remote connection problem |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: