Re: I have a need to run PostgreSQL on a windows 2000 server

H. Krenske schrieb:
> Can you point me to a location where I can get information to install 
> and configure PostgreSQL on a W2K server so that it can be accessed 
> using and the ODBC interface.
If you use the binary installer version it's just a few clicks and a wee 
bit of editing the config-files.

> I program in powerbuilder and so far I have been able to use  this 
> strategy in front of an early version of PostgreSQL running in RH7.2 
> as well as MS SQL and Sybase SQL anywhere with very little code 
> modification.
The configuration of PG on RH7 shouldn't be all that much different than 
on Windows.
> However in front of PostgreSQL on windows 2000 it returns the error
> SQLSTATE=08001
> Could not connect to the server;
> Could not connect to the remote socket.

Looks like a network/access-rights issue to me.

1)   Do you run any firewall on the Windows server that prohibits access 
to port  5432  ?

2)   Did you enable the option that postmaster should listen for network 
clients?

3)   Have you included the clients IP into the pg_hba.conf file within 
the datadirectory?

4)   Have you tried to access your PG on Windows without ODBC by psql or 
PgAdmin so that you can rule out network issues?