Re: setting up PostgreSQL on Linux RHL9 to allow ODBC

Thanks to William and everyone else who answered this.   It works like a
charm!!  PostgreSQL rules!

Susan




                   
                           William Yu
                   
                      <wyu@talisys.com>              To:       pgsql-general@postgresql.org
                   
                           Sent by:                  cc:
                   
                                                     Subject:  Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to
allowODBC connections  

                   
                      pgsql-general-owner@pos         |-------------------|
                   
                      tgresql.org                     | [ ] Expand Groups |
                   
                                                      |-------------------|
                   

                   
                           06/22/2005 08:56
                   
                      PM
                   

                   

                   




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