Bug #64871 Excel crashes during pivot table or database connection setup
Submitted: 4 Apr 2012 20:11 Modified: 29 May 2013 6:21
Reporter: Jim Van Overschelde Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.1.10 OS:Microsoft Windows (7 Pro)
Assigned to: Bogdan Degtyariov CPU Architecture:Any

[4 Apr 2012 20:11] Jim Van Overschelde
Description:
Installed newest odbc connector (5.1.10), 32-bit, 64-bit, and both on 64-bit Win7 Pro system using excel pro plus 2010 (14.0.6112.5000, 64-bit).  
Configured odbc data source mysql 32-bit and mysql 64-bit and both test connection successfully.  

When attempting to connect excel to mysql via odbc connections, it crashes as described below.  

How to repeat:
Insert, pivot table, use an external data source (choose connection), browse more, new source, odbc dsn, dsn mysql 32-bit (or 64-bit),  select specific table (check on "connect to a specific table") and it works fine.  Uncheck "connect to a specific table", click next, finish and excel crashes.  Crash report is:
Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	EXCEL.EXE
  Application Version:	14.0.6112.5000
  Application Timestamp:	4e9b2b32
  Fault Module Name:	myodbc5.dll
  Fault Module Version:	5.1.10.0
  Fault Module Timestamp:	4f1ec25e
  Exception Code:	c0000005
  Exception Offset:	0000000000024833
  OS Version:	6.1.7601.2.1.0.256.48
  Locale ID:	1033

Additional information about the problem:
  LCID:	1033
  skulcid:	1033

Suggested fix:
Uninstall 5.1.10 and install 5.1.8 and it everything works fine.
[4 Apr 2012 20:18] Jim Van Overschelde
BTW, I tried 5.1.10 on two different windows 7 pro machines with same outcomes.
[17 Apr 2012 5:30] Bogdan Degtyariov
Jim, is the problem repeatable in 32-bit excel?
[17 Apr 2012 11:56] Jim Van Overschelde
I don't have access to a 32-bit version of excel.
[1 May 2012 10:50] Bogdan Degtyariov
When I click "Browse for More..." button Excel displays the dialog for opening a file DSN. MySQL Connector/ODBC does not officially support file DSNs. Did you try opening previously created System DSN?
[2 Jun 2012 1:00] Bugs System
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".
[29 May 2013 6:21] Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.