[EMAIL PROTECTED] (Jodi Kanter) writes:
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_00D1_01C17CBA.DEDC5EF0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I am trying to connect to postgres via ODBC so that I can use
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. Oth
> ... 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 on the server witth postgres. If that fails
then you know you have a sockets problem and n
Thanks to those that have responded to my issue. I
have done all that I think was recommended:
My Windows workstation has the psqlODBC
driver
I added ODBC extensions to the base
catalogs
I added the -i switch to my postmaster startup in
order to turn on TCPIP connections
I modified my pg_h
om: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter
Sent: Tuesday, December 04, 2001 11:58 AM
To: Postgres Admin List
Subject: [ADMIN] setting up ODBC
I am trying to connect to postgres via ODBC so that I can use Visio. I have
installed psqlODBC on my windows 2000 workstation and
> I am trying to connect to postgres via ODBC so that I can use Visio. I have
>installed psqlODBC on my windows 2000 workstation and am trying to get to our
>postgres database located on a Linux machine.
> Do I need to enable ODBC on the Linux side? or just configure the driver on my
>workstati
I am trying to connect to postgres via ODBC so that
I can use Visio. I have installed psqlODBC on my windows 2000 workstation and am
trying to get to our postgres database located on a Linux machine.
Do I need to enable ODBC on the Linux side? or just
configure the driver on my workstation?
I
