Thread: PostgreSQL ODBC Driver Help
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.
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
On Tue, Feb 15, 2011 at 12:46 PM, A.M. <agentm@themactionfaction.com> wrote: > 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. I have been using that actual .PDF as a guide and I guess it's different on Office 2007 than show on that site using Office 2003. I guess I will keep searching to find out what I need to do in order to connect Office 2007 Excel or Access to PostgreSQL.