Mail Merge / DSN / Data Link / MySQL

[Bob Young]

Hello all,



I have been using mySQL for years for my projects to generate documents (Word) and reports (Excel). I usually install ODBC driver, open Word, click Mail Merge, Select Recipients, New Source, ODBC DSN, I select the DSN I configured using C:\Windows\SysWOW64\odbcad32.exe (for installing 32bit ODBC Connector), complete the wizard using the DSN and user / pass that worked when I setup the DSN.

When the wizard finishes I get "Test connection failed because of an error in initializing provider. Catastrophic failure."

I need to be able to connect Word 2007 to the mySQL server to pull data and merge documents...

HELP PLEASE !!! I have never had these issues before... specs below.

Win 7 64bit
Word / Office 2007
32bit ODBC mySQL-connector-ODBC-5.1.10-win32
DSN setup using the 32bit installer C:\Windows\SysWOW64\odbcad32.exe

Any help is appreciated, I have also tried the 64 bit ODBC for the hell of it to no avail... I may try to install in XP mode, I never had these problems with XP.

FYI when setting up the DSN everything goes as expected and I am able to connect to the dbase. Its only when Word uses the "Data Link Properties" dialog that it fails.

Thanks in advance...

Bob