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.