Hello,
I think I must be missing something fundamental but for the life of me I’m not able to figure it out. Hopefully someone here will be kind enough to point me in the right direction. Essentially I am trying to setup a mail merge between Microsoft Word and a postgresql database. I’m on Windows XP with MS Word 2002.
I have setup a DSN for the database I’m trying to connect to with the following info: DATABASE: production, SERVER: ip address, PORT: 5432.
Then I go into MS Word and choose Tools->Letters and Mailings->Mail Merge Wizard.
I then chose Browse for a database.
I’m then prompted to choose a data source and I chose “+Connect to new data source”
Next I choose ODBC DSN and choose the data source I’d earlier created.
Then I enter user name and password and choose test.
I get the following error: “Test connection failed because of an error in initializing provider. blank
The other variation I try is instead of choosing “Connect to new data source” I click the “New Source…” button.
It then starts with connect string instead of data source name chosen.
I click build next to the connect string field and fill in the database, server ip address, port and password info.
I then get the following error: “Operation cannot be executed because an error occurred during connection to the driver.”
I figured out how to trace the ODBC drivers and I’ve attached the SQL.LOG file. I just downloaded the window’s driver from the postgres site on Friday so I should have the most recent versions.
I’ve configured the postgres server to allow host connections from all IP’s on my subnet. I’ve also set tcpip_socket=true in postgresql.conf.
This is all the info I can think of attaching at the moment. Please let me know if you need anything else to make this work.
Thanks for your time.
Sincerely,
Tim LoGrasso