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:
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?