Thread: setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

Hi,
I have seen a bunch of different documentation on how to set up to allow
ODBC, but I am a little confused about how much/what has to be set up to
allow an ODBC connection from Windows (mostly 2003, some XP) to an existing
PostgreSQL (7.4.6)  database on Linux (RedHat 9  version 2.4.20-6smp).

Most of the documentation is talking about setting up Unix to Unix odbc, or
Windows to Windows, not Windows to Unix/Linux.

Some documentation talks about installing the "full" distribution on
Windows, but I just want to allow some Windows software that "speaks" ODBC
(SilkTest) to be able to connect to an existing database.


In the document
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat,  it
says to download rpms and install them, but I don't really see any rpms for
this.  I see source distributions at
http://www.postgresql.org/ftp/odbc/versions/src/, but nothing for version
7.4, just 7.3 and 8.0.  I am reluctant to upgrade to 8.0, as I am not sure
it is stable yet, and my installation is running so well.


The howto-redhat document also talks about running:




       psql -d template1 -f /usr/share/pgsql/odbc.sql





to modify template1, but what about existing databases?

I'm somewhat nervous about doing anything to potentially mess up anything
on my Linux server, as this is a production database.

Then, you have to set up the iodbc driver manager, etc.  On this server, I
have had some issues with using rpm's in the past, and have often had to
resort to building things myself (configure, make, etc.)

I'm also not sure about how to specify a DSN to do the connection from the
Windows side (I'm primarily a Unix/Linux person).

Does anyone have any specific advice/experiences to offer on setting this
up as simply as possible?

Thanks,
Susan




----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------

There's nothing on the server side that needs to be configured for
Windows clients to access Postgres via ODBC. As long as TCP/IP is turned
on. Just add a data source and configure the server
ip/name/port/database/etc.




SCassidy@overlandstorage.com wrote:
> Hi,
> I have seen a bunch of different documentation on how to set up to allow
> ODBC, but I am a little confused about how much/what has to be set up to
> allow an ODBC connection from Windows (mostly 2003, some XP) to an existing
> PostgreSQL (7.4.6)  database on Linux (RedHat 9  version 2.4.20-6smp).
>
> Most of the documentation is talking about setting up Unix to Unix odbc, or
> Windows to Windows, not Windows to Unix/Linux.
>
> Some documentation talks about installing the "full" distribution on
> Windows, but I just want to allow some Windows software that "speaks" ODBC
> (SilkTest) to be able to connect to an existing database.
>
>
> In the document
> http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat,  it
> says to download rpms and install them, but I don't really see any rpms for
> this.  I see source distributions at
> http://www.postgresql.org/ftp/odbc/versions/src/, but nothing for version
> 7.4, just 7.3 and 8.0.  I am reluctant to upgrade to 8.0, as I am not sure
> it is stable yet, and my installation is running so well.
>
>
> The howto-redhat document also talks about running:
>
>
>
>
>        psql -d template1 -f /usr/share/pgsql/odbc.sql
>
>
>
>
>
> to modify template1, but what about existing databases?
>
> I'm somewhat nervous about doing anything to potentially mess up anything
> on my Linux server, as this is a production database.
>
> Then, you have to set up the iodbc driver manager, etc.  On this server, I
> have had some issues with using rpm's in the past, and have often had to
> resort to building things myself (configure, make, etc.)
>
> I'm also not sure about how to specify a DSN to do the connection from the
> Windows side (I'm primarily a Unix/Linux person).
>
> Does anyone have any specific advice/experiences to offer on setting this
> up as simply as possible?
>
> Thanks,
> Susan
>
>
>
>
> ----------------------------------------------------------------------------------------------
> See our award-winning line of tape and disk-based
> backup & recovery solutions at http://www.overlandstorage.com
> ----------------------------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

On 22 Jun 2005 at 8:59, SCassidy@overlandstorage.com wrote:

> I have seen a bunch of different documentation on how to set up to
> allow ODBC, but I am a little confused about how much/what has to be
> set up to allow an ODBC connection from Windows (mostly 2003, some XP)
> to an existing PostgreSQL (7.4.6)  database on Linux (RedHat 9  version
> 2.4.20-6smp).


Hi,

All you need is the Windows ODBC driver, which you install on the
client machine, and then configure it to talk to the Linux server on
port 5432 (set by default).

--Ray.


>
> Most of the documentation is talking about setting up Unix to Unix odbc, or
> Windows to Windows, not Windows to Unix/Linux.
>
> Some documentation talks about installing the "full" distribution on
> Windows, but I just want to allow some Windows software that "speaks" ODBC
> (SilkTest) to be able to connect to an existing database.
>
>
> In the document
> http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat,  it
> says to download rpms and install them, but I don't really see any rpms for
> this.  I see source distributions at
> http://www.postgresql.org/ftp/odbc/versions/src/, but nothing for version
> 7.4, just 7.3 and 8.0.  I am reluctant to upgrade to 8.0, as I am not sure
> it is stable yet, and my installation is running so well.
>
>
> The howto-redhat document also talks about running:
>
>
>
>
>        psql -d template1 -f /usr/share/pgsql/odbc.sql
>
>
>
>
>
> to modify template1, but what about existing databases?
>
> I'm somewhat nervous about doing anything to potentially mess up anything
> on my Linux server, as this is a production database.
>
> Then, you have to set up the iodbc driver manager, etc.  On this server, I
> have had some issues with using rpm's in the past, and have often had to
> resort to building things myself (configure, make, etc.)
>
> I'm also not sure about how to specify a DSN to do the connection from the
> Windows side (I'm primarily a Unix/Linux person).
>
> Does anyone have any specific advice/experiences to offer on setting this
> up as simply as possible?
>
> Thanks,
> Susan
>
>
>
>
> ----------------------------------------------------------------------------------------------
> See our award-winning line of tape and disk-based
> backup & recovery solutions at http://www.overlandstorage.com
> ----------------------------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

Not quite correct. TCP needs to be turned on AND an according entry in
pg_hba.conf needs to be set up - otherwise the server will just decline to
talk to the client.
Also - if you're on XP you might want to check the "firewall" settings - which
if configured wrong could potentially block connections on port 5432. If you
have a default setup of XP it should be fine though.


On Wednesday 22 June 2005 08:56 pm, William Yu wrote:
> There's nothing on the server side that needs to be configured for
> Windows clients to access Postgres via ODBC. As long as TCP/IP is turned
> on. Just add a data source and configure the server
> ip/name/port/database/etc.
>
> SCassidy@overlandstorage.com wrote:
> > Hi,
> > I have seen a bunch of different documentation on how to set up to allow
> > ODBC, but I am a little confused about how much/what has to be set up to
> > allow an ODBC connection from Windows (mostly 2003, some XP) to an
> > existing PostgreSQL (7.4.6)  database on Linux (RedHat 9  version
> > 2.4.20-6smp).
> >
> > Most of the documentation is talking about setting up Unix to Unix odbc,
> > or Windows to Windows, not Windows to Unix/Linux.
> >
> > Some documentation talks about installing the "full" distribution on
> > Windows, but I just want to allow some Windows software that "speaks"
> > ODBC (SilkTest) to be able to connect to an existing database.
> >
> >
> > In the document
> > http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat,
> > it says to download rpms and install them, but I don't really see any
> > rpms for this.  I see source distributions at
> > http://www.postgresql.org/ftp/odbc/versions/src/, but nothing for version
> > 7.4, just 7.3 and 8.0.  I am reluctant to upgrade to 8.0, as I am not
> > sure it is stable yet, and my installation is running so well.
> >
> >
> > The howto-redhat document also talks about running:
> >
> >
> >
> >
> >        psql -d template1 -f /usr/share/pgsql/odbc.sql
> >
> >
> >
> >
> >
> > to modify template1, but what about existing databases?
> >
> > I'm somewhat nervous about doing anything to potentially mess up anything
> > on my Linux server, as this is a production database.
> >
> > Then, you have to set up the iodbc driver manager, etc.  On this server,
> > I have had some issues with using rpm's in the past, and have often had
> > to resort to building things myself (configure, make, etc.)
> >
> > I'm also not sure about how to specify a DSN to do the connection from
> > the Windows side (I'm primarily a Unix/Linux person).
> >
> > Does anyone have any specific advice/experiences to offer on setting this
> > up as simply as possible?
> >
> > Thanks,
> > Susan
> >
> >
> >
> >
> > -------------------------------------------------------------------------
> >--------------------- See our award-winning line of tape and disk-based
> > backup & recovery solutions at http://www.overlandstorage.com
> > -------------------------------------------------------------------------
> >---------------------
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--
    UC

--
Open Source Solutions 4U, LLC    2570 Fleetwood Drive
Phone:  +1 650 872 2425        San Bruno, CA 94066
Cell:   +1 650 302 2405        United States
Fax:    +1 650 872 2417