MySQL Bugs: #55523: ODBC 64 bit Mysql-connector not recognized by Ms Excel 2007

Bug #55523	ODBC 64 bit Mysql-connector not recognized by Ms Excel 2007
Submitted:	23 Jul 2010 19:23	Modified:	2 Aug 2010 13:38
Reporter:	Mike Murphy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51.27	OS:	Windows (windows 7 64 bit)
Assigned to:	Tony Bedford	CPU Architecture:	Any
Tags:	ODBC, ODBC 64 bit driver for Excel

Description:
When attempting to connect the mysql-connector/ODBC driver for Excel (64 bit windows 7 ), the driver installs per instructions found on 
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-installation-binary-windows.html#con...
The driver can be viewed and set up per the instructions and can be verified by looking in the windows7 ODBC Manager. when opening Excel 2007 and going to the Data -> From Other Sources -> MS Query, you can select the DSN and you can connect successfully to the data base, however, when attempting to import the data, there is an error message that there is an architectural mismatch and the process is halted.

Verified our Red Hat production server(www.rackspace.com) is using 64 bit Mysql
Verified client is running MS Windows Pro 64 bit 
Verified client PC is Amd 64 bit
Verified MS Excel 2007 SP2

How to repeat:
Follow the procedure outlined above and in the Mysql Docs at the above link.

Suggested fix:
For now, I installed the 32 bit windows 7 msi ODBC connector and everything seems to work fine. 

Not sure what element is causing the error (server , OS, or Excel)

Hi Mike and thanks for your report.

A brief glance on the mentioned page shows the steps will work *only* on 32bit windows.

Whoever is familiar with MS products knows Office is a 32bit application while you installed c/ODBC as 64-bit one and in 64-bit system folder (System32). Further more, the standard driver manager (Start/Control Panel/Administrative tools/Data Sources (ODBC) is a *x64* one thus *none* of the DSN's defined there are available to Office/MSQuery apps. You need to start %windir%\sysWOW64\odbcad32.exe to add DSN that can be used in Office.

The proper thing to do would be to install from MSI which will put both 32 and 64 bit drivers in a proper place. I have W2K8R2 x64 with Office2007 and never had such trouble.

Since the page mentioned could be misleading, I'll set this to verified and assign to docs team.

Documentation has been updated.