Re: ODBC Stuff

Ed Loehr wrote:
>
> "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.

Oops...I didn't read carefully that you have a windows perl app.  I think
there is a perl module at CPAN for accessing via ODBC, though I've not used
it ...

http://search.cpan.org/doc/GSAR/libwin32-0.151/blib/lib/Win32/ODBC.pm

Regards,
Ed Loehr