Re: setting up ODBC

You can also use netstat to see if it is listening.

Postgres usually listens on port 5432 right?  so examine netstat -na and
see if anything is listening on tcp port 5432.

If you are using a recent version of linux, netstat has the -p option that
will name the process listening on that port. Otherwise, use lsof to find
that.

If you find it is listening, make sure the name/password you are using
works.  Try psql to verify this.

-J

On Tue, 4 Dec 2001, Derek Neighbors wrote:

> > ... I am still getting the following error when trying to connect:
> > ODBC--call failed
> > could not connect to the server
> > could not connect to remote socket #101
> >
> > any thoughts?
> Try psql -h localhost <dbname> on the server witth postgres. If that fails
> then you know you have a sockets problem and not an odbc problem.
>
> -Derek
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>