Skip site navigation (1) Skip section navigation (2)

Re: ODBC Stuff

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net>, "PostgreSQL::General List" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: ODBC Stuff
Date: 2000-04-27 19:26:28
Message-ID: 39089464.2FF00D2C@austin.rr.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Karel ZakDate: 2000-04-27 19:48:21
Subject: Re: [SQL] US Date Style
Previous:From: Karl DeBisschopDate: 2000-04-27 19:23:35
Subject: Re: ODBC Stuff

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group