MySQL Bugs: #67045: Can not get ODBC connector to work with Windows 7 64 bit running Excel 32 bit.

Bug #67045	Can not get ODBC connector to work with Windows 7 64 bit running Excel 32 bit.
Submitted:	2 Oct 2012 1:12	Modified:	2 Oct 2012 13:58
Reporter:	Brian Haw	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.2.2	OS:	Windows (64 bit)
Assigned to:		CPU Architecture:	Any
Tags:	Excel 32 bit

Description:
I have Windows 7 64 bit with Excel 2010 32 bit and I can not get the ODBC to work. If I load the 32 bit version of the odbc connector (5.2.2) I can not create a DSN. If I load the 64 bit odbc connector (5.2.2) then I can create a DSN (passed test) but Excel does not recognize the DSN. It does work with Windows 7 32 bit and Excel 2010 32 bit.

How to repeat:
Test 32 or 64 bit ODBC connector on Windows 7 64 bit with Microsoft 32 bit products.

Suggested fix:
Have 32 bit ODBC connector work with Windows 7.

we at Webyog has a FAQ about same.  Maybe it helps:
http://www.webyog.com/faq/content/17/187/en/problems-creating-a-functional-dsn-on-64-bit-w...: "After installing a 32 bit ODBC driver it does not show up as an option when configuring a DSN from Control Panel .. Administration .. Data Sources. The reason is the ODBC manager launched from Control Panel it is a 64 bit version of the ODBC manager that handles 64 drivers only.  64 bit Windows does however ship with a 32 bit version of the ODBC Manager. It is in the folder {System_Drive}:\Windows\SysWOW64 and is named 'odbcad32.exe'.  To create .."

Please try what Peter wrote. Thanks.

Using the 32 ODBC Data Source Administrator located in the \Windows\SysWOW64 folder solved my problem. 

Thank you