MySQL Bugs: #74369: Excel plugin install fails newer "Visual Studio Tools for Office 2010 64 bit"

Bug #74369	Excel plugin install fails newer "Visual Studio Tools for Office 2010 64 bit"
Submitted:	14 Oct 2014 7:55	Modified:	5 Jan 2015 23:09
Reporter:	Keith Hollman	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S2 (Serious)
Version:	5.6.21	OS:	Windows (W7 W8)
Assigned to:		CPU Architecture:	Any

Description:
When installing MySQL for Windows Installer, just to install MySQL for Excel, if you have preinstalled the latest version of "Visual Studio Tools for Office 2010 64 bit" (http://www.microsoft.com/en-us/download/details.aspx?id=44074) and then do a fresh install of MySQL Installer using 1 of the 3 options Full, Client or Developer, the GUI doesn't detect that the tools are installed, and then fails, and you're unable to install MySQL for Excel. Applies to both W7 and W8 platforms. You can install everything else.

How to repeat:
- Make sure nothing MySQL is installed.
- Also, Visual Studio Tools for office 2010 64 bit not installed.
- Install the VSTools from link http://www.microsoft.com/en-us/download/details.aspx?id=44074.
- Download and install "MySQL for Windows Installer 5.6.21.1", Windows Installer XML 3.6.3303.
- choose 1 of the 3 options: Full, Developer or Client.
- (If you try Custom, Applications, MySQL for Excel, MySQL for Excel 1.3 I get a different error that I'll open another bug for.)
- On the "Check Requirements" page, single click on MySQL for Excel, and the comments underneath in Requirements state "Visual Studio Tools for Office 2010 64 bits is not installed" and Status: is blank.
- Click on Execute to install the Excel plugin.
- The wizard comes up, click on Next.
- Click on Accept the License Terms, and then on Install.
- A dialogue box comes up stating that "A later version of Visual Studio Tools for Office Runtime (x64) is already installed". Click OK.
- "An error occurred during setup" window comes up, A message states "The following error occurred during setup: Installation failed" and a link to the MS Product Support Center and a Finish button.
- It takes you back to the Check Requirements screen.

Suggested fix:
- Allow later versions of "Visual Studio Tools for office 2010 64 bit" on the initial check requirements screen or search for an updated version and not just a specific version.
- Workaround: to download the specific package from http://dev.mysql.com/downloads/windows/excel/ and not use the Windows Installer for Excel.

Thank you for the bug report. This bug is related to http://bugs.mysql.com/bug.php?id=74370 which you have also reported.

Hi Keith, 

Just to say thanks for checking this out and logging the various installation faults after you and I corresponded.  As a potential business customer for MySQL Enterprise, the installation problems in the Community edition have prejudiced me against recommending use of MySQL in a business environment to my employer at the moment.  We were looking for integration of MySQL with Excel as a simple DB front end for our end users, and it is exactly that capability that is failing install.  

Let me know when there is a reliable installer available and I will maybe try again?

Thanks,
Rob Sherratt

http://bugs.mysql.com/bug.php?id=78839 marked as duplicate of this one.