ok got postgres odbc driver on win2k, but cannot connect
got the win2k postgres odbc driver, but cannot connect
to the linux postgres. not sure what settings to use
or how best to trouble shoot it.
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
---- Eric Webber streethockey@ureach.com wrote ----
Show quoted text
Date: Wed, 6 Mar 2002 08:16:08 -0500
To: lxp-general@commandprompt.com, pgsql-general@postgresql.org,
pgsql-odbc@postgresql.org
From: Eric Webber <streethockey@ureach.com>
Reply-to: <streethockey@ureach.com>
Subject: [lxp-general] Win2k ODBC Data Sources do NOT include PostgresFor some reason, my win2k ODBC data sources do not
include the option to add Postgres. How do I add that
as an option to the list of ODBC sources which can be
added ?I have a postgres database on linux I wish to access
via thekompany's DataArchitect tool which is running
on Win2k. Is there an ODBC driver of Win2k for postgres
running on Linux ?warmest regards,
Eric Sean Webber
streethockey@ureach.com________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
_______________________________________________
lxp-general mailing list
lxp-general@commandprompt.com
https://secure.linuxports.com/mailman/listinfo/lxp-general
Taking a wild guess here -- make sure that you're not filtering
the ports at the OS level. Recent versions of RH Linux (and probably
many other distros) use fairly stringent ipchains rules for
security. You may need to open up port 5432. Under RH Linux, you
add this to /etc/sysconfig/ipchains (and then restart ipchains):
-A input -s 127.0.0.1 -d 0/0 5432 -p tcp -y -j ACCEPT
(change 127.0.0.1 to your Win2K machine's IP address)
Jason Priebe
Mi-Co
http://www.mi-corporation.com/
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Eric Webber
Sent: Wednesday, March 06, 2002 8:29 AM
To: lxp-general@commandprompt.com; pgsql-general@postgresql.org;
pgsql-odbc@postgresql.org
Subject: [GENERAL] ok got postgres odbc driver on win2k, but cannot
connectgot the win2k postgres odbc driver, but cannot connect
to the linux postgres. not sure what settings to use
or how best to trouble shoot it.________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag---- Eric Webber streethockey@ureach.com wrote ----
Date: Wed, 6 Mar 2002 08:16:08 -0500
To: lxp-general@commandprompt.com, pgsql-general@postgresql.org,
pgsql-odbc@postgresql.org
From: Eric Webber <streethockey@ureach.com>
Reply-to: <streethockey@ureach.com>
Subject: [lxp-general] Win2k ODBC Data Sources do NOT include PostgresFor some reason, my win2k ODBC data sources do not
include the option to add Postgres. How do I add that
as an option to the list of ODBC sources which can be
added ?I have a postgres database on linux I wish to access
via thekompany's DataArchitect tool which is running
on Win2k. Is there an ODBC driver of Win2k for postgres
running on Linux ?warmest regards,
Eric Sean Webber
streethockey@ureach.com________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
_______________________________________________
lxp-general mailing list
lxp-general@commandprompt.com
https://secure.linuxports.com/mailman/listinfo/lxp-general---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
On Wed, Mar 06, 2002 at 08:28:58AM -0500, Eric Webber wrote:
got the win2k postgres odbc driver, but cannot connect
to the linux postgres. not sure what settings to use
or how best to trouble shoot it.
What have you got in ${PGDATA}/pg_hba.conf ?
Patrick