Thread: Setting up pgsql for ODBC

Setting up pgsql for ODBC

From
Stephan Hochhaus
Date:
Hello,

I am currently working on a solution to set up PostgreSQL on Mac OS X
Server 10.3.3 and I want to enable ODBC support so that our client PCs
can continue using their MS-Access GUI which they are used to. My
questions:

- Is ODBC included in you average build of PostgreSQL or would I have
to download any add-on packages?
- Does anyone have experience with Access/PostgreSQL? Is it working
well? I have my doubts concerning the MS-anomalies I have found in
other areas of work..

Stephan


Re: Setting up pgsql for ODBC

From
Jeff Eckermann
Date:
--- Stephan Hochhaus <stephan@yauh.de> wrote:
> Hello,
>
> I am currently working on a solution to set up
> PostgreSQL on Mac OS X
> Server 10.3.3 and I want to enable ODBC support so
> that our client PCs
> can continue using their MS-Access GUI which they
> are used to. My
> questions:
>
> - Is ODBC included in you average build of
> PostgreSQL or would I have
> to download any add-on packages?

You need to download and install the ODBC driver on
the client pc's.  Get that from here:

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

You don't need to do anything on the server.

> - Does anyone have experience with
> Access/PostgreSQL? Is it working
> well? I have my doubts concerning the MS-anomalies I
> have found in
> other areas of work..

Generally Access works well using linked PostgreSQL
tables.  There are some issues with running Access
client/server, and these apply regardless of what
backend database you use.  The "Access Developers
Handbook" has a good coverage of these issues.  There
is also a microsoft newsgroup devoted to Access
client/server.  You will find some useful material on
gborg (the link I provided above); you will also find
useful material by searching the archives of the
pgsql-odbc list.

If you need to migrate Access data to PostgreSQL, I
have had good success using the Database Migration
Wizard that comes with PgAdminII.  Unfortunately this
is now a legacy application, so you will need to
search for it (PgAdminIII apparently does not yet have
this feature).

>
> Stephan
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)





__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover