On Feb 15, 2011, at 12:25 PM, Carlos Mennens wrote: > 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. I googled "connect excel postgresql" and found this: http://port25.technet.com/videos/research/excelopendbprimer.pdf which seems to take one through all the steps. Cheers, M -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
