Thread: How to hook up Access to Postgres?

How to hook up Access to Postgres?

From
Scott Chapman
Date:
My Access database programmer is interested in hooking it up to Postgresql!

I haven't done anything with ODBC.  I assume it's needed to do this?
I'd appreciate some directions as to what is required to make this connection.
He knows nothing about Unix and I know next to nothing about Access so it
should be an interesting "meeting of the minds".

Any help would be greatly appreciated!
Scott


Re: How to hook up Access to Postgres?

From
"scott.marlowe"
Date:
Go to http://gborg.postgresql.org/project/psqlodbc/projdisplay.php to get
the latest odbc driver for Windows.  It's pretty easy, I hook folks up to
postgresql via ODBC all the time.

On Tue, 6 May 2003, Scott Chapman wrote:

> My Access database programmer is interested in hooking it up to Postgresql!
>
> I haven't done anything with ODBC.  I assume it's needed to do this?
> I'd appreciate some directions as to what is required to make this connection.
> He knows nothing about Unix and I know next to nothing about Access so it
> should be an interesting "meeting of the minds".

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.

He shouldn't have to do anything else on the Unix side, all the rest of
the configuration is handled in windows / odbc.


Re: How to hook up Access to Postgres?

From
Doug McNaught
Date:
"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.

> 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.

-Doug

Re: How to hook up Access to Postgres?

From
"scott.marlowe"
Date:
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.


Re: How to hook up Access to Postgres?

From
Jeff Eckermann
Date:
--- "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> On 6 May 2003, Doug McNaught wrote:

> > 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.

AFAIK (based on past posts to the odbc list), this is
not needed for odbc access from windows clients.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


Re: How to hook up Access to Postgres?

From
"scott.marlowe"
Date:
On Wed, 7 May 2003, Jeff Eckermann wrote:

> --- "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> > On 6 May 2003, Doug McNaught wrote:
>
> > > 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.
>
> AFAIK (based on past posts to the odbc list), this is
> not needed for odbc access from windows clients.

I was just looking at the output of 7.3.x and it looks like the
switch is gone and odbc connectivity is automatic now. sweet.