Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2012, 08:58 AM
Bob Young Bob Young is offline Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL Office 2007
Novice
Mail Merge / DSN / Data Link / MySQL
 
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 Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL Office 2007
Novice
Mail Merge / DSN / Data Link / MySQL
 
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 Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
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 Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,902
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
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 Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL 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 Mail Merge / DSN / Data Link / MySQL Windows 7 64bit Mail Merge / DSN / Data Link / MySQL 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 / DSN / Data Link / MySQL 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 Mail Merge 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 03:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft