Thread: ok got postgres odbc driver on win2k, but cannot connect

ok got postgres odbc driver on win2k, but cannot connect

From
Eric Webber
Date:
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 ----

> 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 Postgres
>
>
> For 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
>
>

Re: [GENERAL] ok got postgres odbc driver on win2k, but cannot connect

From
"Jason Priebe"
Date:
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/

> -----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
> 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 ----
>
> > 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 Postgres
> >
> >
> > For 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?
>
> http://archives.postgresql.org
>

Attachment