Re: How to hook up Access to Postgres? - Mailing list pgsql-general

From scott.marlowe
Subject Re: How to hook up Access to Postgres?
Date
Msg-id Pine.LNX.4.33.0305070911380.8765-100000@css120.ihs.com
Whole thread Raw
In response to Re: How to hook up Access to Postgres?  (Doug McNaught <doug@mcnaught.org>)
Responses Re: How to hook up Access to Postgres?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-general
On 6 May 2003, Doug McNaught wrote:

> "scott.marlowe" <scott.marlowe@ihs.com> writes:
>
> > If postgresql was built with the --enable-odbc switch, you're done the on
> > the postgresql end.  'pg_config --configure' will tell you if it was.  If
> > it wasn't, you may need to rebuild postgresql to get it working.
>
> What does --enable-odbc do?  I didn't set it and I'm running fine with
> Windows clients.

It tells postgresql to build with the odbc interface.  RPM and
dpkg installs are usually built with it, so if you're running from
packages it's probably already been done for you.

> > He shouldn't have to do anything else on the Unix side, all the rest of
> > the configuration is handled in windows / odbc.
>
> I'll second that--I have an Access app working pretty well against
> Posgres 7.3.2.

Yeah, I have a couple of Windows / FoxPro / Access / MSSQL folks using my
postgresql test server for testing and it's pretty straight forward.
Install postgresql's windows odbc driver, create a connector, connect.


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Small bug in postgres' ./configure script and invalid
Next
From: "Jimmie H. Apsey"
Date:
Subject: Re: Postgres client/server parameters?