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

hi, if the client machine is another linux , what is the correct way to
configure ODBC

thanks

Hugo

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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
> -------------------------------------------------------------
> Raymond O'Donnell http://www.galwaycathedral.org/recitals
> rod(at)iol(dot)ie Galway Cathedral Recitals
> -------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>