MySQL Bugs: #61054: Excel crashes, creating ODBC connection with 5.1.8

Bug #61054	Excel crashes, creating ODBC connection with 5.1.8
Submitted:	4 May 2011 13:08	Modified:	14 Jun 2011 3:08
Reporter:	Veronica Brown	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.1.8	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Created a System DSN data source using MySQL ODBC driver 5.1.8 and it tested successfully. 

Tried recreating a query in an Excel spreadsheet (Excel 2007), and Excel immediately crashes before the query can be created. I've tried creating the query using both the Excel Connection Wizard and Microsoft Query, on both Windows Vista and Windows 7. 

I can't get existing Excel queries to work since I updated the driver.

A great workaround for me would be to revert to 3.51.28 if anyone can help me figure out how to see Asian character sets (need both Chinese and Japanese in one query). Setting the Character Set to utf-8 using driver 3.51.28 doesn't do the trick.

Many thanks,
Veronica Brown

How to repeat:
Create a System DSN data source using MySQL ODBC driver 5.1.8.
Open Excel 2007, blank file. Put cursor in cell A1.
On Data ribbon of the menu, select Get External Data > From Other Sources.
Select ODBC DSN; Next.
Select the data source using 5.1.8. Next.
Crash.

Thank you for the bug report. Do you have update all the service packages for Excel?. Otherwise please do and try again. Thanks.

Yes. To be sure, I downloaded the Office 2007 SP2 just now, and tried reinstalling, and saw confirmation that the latest SP is already installed.

Could you please create ODBC trace log for the crash and attach it here? thank you in advance.

ODBC Trace file, Excel crash

Attachment: SQL.LOG (application/octet-stream, text), 2.13 KiB.

Thanks for your help, Larwin. Please see attached.
The last lines show the SQL statement being executed from within Excel when Excel crashes.

Many thanks, -vb.

P.S. I neglected to say this outright before:

When I use an ODBC connection that uses the 3.51.28 driver, the query executes without a problem. I need Asian character support, though--so I really need 5.1.x.

Is there a way to get the .msi for an earlier 5.1.x version of the driver?

-vb.

UPDATE:
Today I uninstalled the driver, and reinstalled it, and am now unable to re-create the problem.

I thought I'd try 5.1.7, and I found a copy on the web.
Tried installing it over 5.1.8, but got error message.
Uninstalled 5.1.8 (Control Panel > Programs and Features)
Installed 5.1.7.
Excel queries executed without crash.

To try to recreate the problem:

Installed 5.1.8 over 5.1.7
Using same data source, Excel queries executed without crash.

Created new data source using 5.1.8.
Excel queries executed without crash.

Deleted all data sources.
Uninstalled 5.1.8.
Reinstalled 5.1.8.
Created new data source.
Excel queries executed without crash.

If you can think of anything else you'd like me to try to re-create the problem, please let me know.

My only step remaining is to see if uninstalling and reinstalling the driver will fix the problem on my *client's* system as well.

If it does, I will report that here.
-vb.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Uninstalling and reinstalling the driver, and re-creating the ODBC connection, appears to have solved the problem. Thanks for your help.