Re: ODBC Stuff

"Roderick A. Anderson" wrote:
>
> Sorry to ask this as I'm sure it's passed throught here but I'm also sure
> I just looked at the messages briefly and then deleted them becuase I
> didn't think I'd ever need the information.
>
> I'm working on a program that will run on a MS Windows platform and I
> want it to use a database (PostreSQL) on a Linux box. From the research
> I've been doing I get the impression that ODBC is the preferred, if not
> the only, method to do this. So I'm hoping someone can point me at some
> simple steps (they don't have to be too detailed) on getting a MS Windows
> application to talk to a PostgreSQL database across a network.
>
> I've made a couple of passes over the unixODBC site and came away with
> a much better understanding but just gave up on the MS (ODBC) site since
> it looked like more of an advertisement than an information site.
>
> The application is being written in perl (ActiveState) and compiled
> with perl2exe to make the installation impact (not a full perl
> installation) on the Windows systems a little lighter.
>
> Any and all pointers apprciated,
> Rod

I found getting Excel on Windows 98 accessing PG on Linux via ODBC to be
pretty straightforward. Basically, just download and install the pg ODBC
driver (v6.50?) from www.postgresql.org and install it on the Win box, make
sure your linux pg server is started with '-i', setup your pg_hba.conf file
on the linux box (see doc at www.postgresql.org), and that should do it,
barring other considerations (firewalls, etc.). You should then be able to
"Get External Data" from Excel.

Regards,
Ed Loehr