PostgreSQL ODBC Driver Help

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL ODBC Driver Help
Date: 2011-02-15 17:25:20
Message-ID: AANLkTi=J0i3mAQ-Qfnbh2zTOas=EbZCF-7t7XY-UojqJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to figure out how I can have users in the office connect
their Microsoft Office 2007 clients to our company database server
running PostgreSQL 8.4.7. I've configured PostgreSQL to accept
incoming connections and allow users to login however I read that I
need to have each client install a MSI pack that allows ODBC drivers
to talk to the database server. I've installed the ODBC driver from
the following URL:

The Drivers can be found at:
PostgreSQL: http://www.postgresql.org/ftp/odbc/versions/msi/

I installed it on the machine running Office 2007 but beyond that I
have no idea how to initialize a connection from Excel or Access to
the database server. Can anyone please help me figure out how to
connect?

I have my 'pg_hba.conf' & 'postgresql.conf' files configured perfectly
to accept incoming SSL connections from my internal network on the
default port for PostgreSQL.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2011-02-15 17:46:10 Re: PostgreSQL ODBC Driver Help
Previous Message pasman pasmański 2011-02-15 16:34:43 Re: read and restore deleted record