MySQL Bugs: #67380: Excel Crashes when connecting to MySQL

Bug #67380	Excel Crashes when connecting to MySQL
Submitted:	25 Oct 2012 19:57	Modified:	26 Oct 2012 13:06
Reporter:	Tony Audi	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.2.2	OS:	Windows (Windows 7 Pro)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any

Description:
I'm running Window 7 Pro 64bit with Microsoft Office 2010 32 bit.

I can install the 5.2.2 32bit MySQL ODBC Driver fine, and add it to "My Data Connections" within Windows with no problem.

When I try to add it into Excel as a Data source, Excel crashes

How to repeat:
Install 32 Bit 5.2.2 Driver on Windows 7 Pro 64 Bit.
Add Driver to "My Data Connections" via Windows control panel.
Launch Excel 2010 32 Bit.
Try to add the MySQL Data connection as an external data source
Excel Crashes.

Hi Tony and thanks for your report. Control panel ODBC administrator is a 64bit app on 64bit OS while, to be used with 32bit SW such as Excel, you need 32bit ODBC administrator. Please see if suggestion from Bug#67045 works for you.

If if does not work for you please describe how to get to the dialog/list you labeled as "My Data Connections".

I was able to find objects labeled as "Existing Connections", "Workbook Connections", "Connections", "Connections from Other Sources", but no "My Data Connections". This is important because we cannot proceed with the bug verification without your feedback.

I did use the 32-Bit ODBC Admin:
C:\Windows\SysWOW64\odbcad32.exe
Without it you can't create a connection to the 32-Bit MySQL driver.

Also, if I use the 64-Bit driver, I get a "Application - Driver compatibility" error from Excel, which makes sense since it's a 32-Bit version of Excel.

This part works fine.  It's when I try to connect from within Excel that the problem occurs.  The exact steps within Excel are:

Open Excel
Click on Data Tab
Click on From Other Sources
Click on From Data Connection Wizard
Select ODBC DSN and click Next
Select the name of the ODBC driver connected created using the Windows ODBC Admin and click Next.
It Shows you a Select Database and Table dialog.
Select the desired database
Unselect the "Connect to a specific table:" checkbox
Click next
Choose a File Name in the "Save Data Connection File and Finish" dialog
Click Finish.
Excel then crashes.

I figured out the problem.  If you don't select a table, it will crash excel.