Re: connect System DSN on windows cli via ODBC to PostgreSQL srv on GNU/Linux

Hello,

> sorry for de lack of info; there's no firewall, postmaster is
> not running with '-i' option but i have the "tcpip_socket = true"

Does netstat (on the server) list the pgsql server listening on 5432?

> in my postgresql.conf; in the hostname a set the IP of the server,
> the port is the default 5432; the psqlODBC driver is 07.03.0200.
>
> Do you know what odbc library on the server could be missing here?

No ODBC library is needed on the server side. Could you connect to the
server with psql or pgadmin from the WinXP (client) machine?
I think 07.03 doesn't have problem with IP (as 08.01 has it) but please
try define hostname with its name.

What gives you on WinXP when you try 'telnet <server IP> 5432' from
command line?

BTW I'm going to holidays for one or two weeks so please reply to the
mailing list. Others could help you too ;-)

Regards,

Luf

P.S. Cc: pgsql-odbc(at)postgresql(dot)org

> Ludek Finstrle <luf(at)pzkagis(dot)cz> escribió:
> i'm trying to connect a 'simple' System DSN in a windowsXP machine
> > through ODBC to the PostgreSQL server 7.4.6 on a GNU/Linux machine,
> > and i'm getting this meessage : "Could not connect to remote socket."
>
> The message means that ODBC driver is unable to connect to the backend.
> What about firewall? Does postmaster running with -i (to accept tcp
> connection) on Linux box? Do you properly set the hostname and port
> number? What psqlODBC driver version do you use?
>
> I'm sorry I have no crystal ball.
>
> Regards,
>
> Luf
>
>
>
> ---------------------------------
> Yahoo! Autos. Más de 12.000 vehículos publicados.
> ¿Qué esperás para vender el tuyo?
> Hacelo ahora y ganate un premio de Yahoo!