Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-26-2012, 08:58 AM
Bob Young Bob Young is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 2
Bob Young is on a distinguished road
Default Mail Merge / DSN / Data Link / MySQL

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
Reply With Quote
  #2  
Old 02-26-2012, 07:22 PM
Bob Young Bob Young is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 2
Bob Young is on a distinguished road
Default

Solved it, had to leave provider drop down blank.
Reply With Quote
  #3  
Old 02-26-2012, 10:23 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,554
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Bob,

As a first step, try repairing Office, via Word Options|Resources|Diagnose. If that doesn't resolve things, check out the discussion here: http://www.wordbanter.com/showthread.php?t=90653
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 02-27-2012, 04:04 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,554
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Bob,

I see you posted the question in two different threads here. Please don't do that.

I've now merged the threads.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-18-2012, 03:11 PM
Moises Moises is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2012
Posts: 2
Moises is on a distinguished road
Default

can you please elaborate?

I get "Provider is not selected. Select a Provider"

Reply With Quote
  #6  
Old 05-18-2012, 03:44 PM
Moises Moises is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2012
Posts: 2
Moises is on a distinguished road
Default

NVM. Raju explains:
http://forums.mysql.com/read.php?37,...581#msg-193581

Leave the Initial Catalog drop down blank!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - If a field is black, take the data from the row below? mikeprent Mail Merge 5 01-05-2012 04:52 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM
How do I set up the fields in mail merge word 07 from my data base mbcrabber Word 4 06-06-2010 01:25 PM
Export from MYSQL (UTF8) to MS Office07(PC) and MS Office08(MAC) .XLSX Evert Tillman Office 0 12-03-2009 08:02 AM
Need help creating a data base for mail merge. acedking90 Mail Merge 0 07-27-2009 11:04 AM


All times are GMT -7. The time now is 08:36 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft