MySQL Bugs: #64229: mysql-connector-odbc-5.1.10-winx64 can not be accessed from Access 2007

Bug #64229	mysql-connector-odbc-5.1.10-winx64 can not be accessed from Access 2007
Submitted:	4 Feb 2012 20:43	Modified:	8 Feb 2012 10:38
Reporter:	first last	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	mysql-connector-odbc-5.1.10-winx64	OS:	Windows (windows 7 up-to-date)
Assigned to:		CPU Architecture:	Any
Tags:	mysql-connector-odbc-5.1.10-winx64

Description:
OUR NOTES:
The following is true on an windows-7 (64-bit) install:

mysql-connector-odbc-5.1.10-winx64: Currently is not working or otherwise
listed in the "Create New Data Source" dialog window. The resulting file
size reported by Win 7's add/remove programs= 21.2MB

Dwnlded from --
http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.10-winx64.m...

mysql-connector-odbc-5.1.10-win32: Currently, will get listed within the
"Create New Data Source" dialog window; but of course nothing beyond that
will function. resulting file size reported by Win 7 add/remove programs=
11.0MB.

Dwnlded from --
http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.10-win32.ms...
-
Access 2007 appears to use: C:\Windows\SysWOW64\odbcad32.exe. In the drivers tab the 'odbc-5.1 is not listed. However, within C:\Windows\System32\obdcad32.exe <driver> tab does in fact have the driver listed; but windows-7 or Access 2007 does not access or otherwise use this file.

How to repeat:
Install mysql-connector-odbc-5.1.10-winx64.msi on a Microsoft 64-bit Windows-7 install, install or otherwise open 'Access 2007' and a test database, left-click 'external data', on the 'Import' section of the 'ribbon' left-click 'more' the left-click 'ODBC Database', Left-click 'OK' then 'new', scroll the list; you wll not see the mysql-connector-odbc-5.1.10-winx64 in the list.

Your MS office/Access is a 32 bit application, I think?

Did you create a 'system DSN' or a 'user DSN'? Only a 'user DSN' will work in such 'mixed bit stack' environment.

Peter
(not a MySQL person)

Maybe this (that I wrote recently) will help BTW:
http://webyog.com/faq/content/17/187/en/problems-creating-a-functional-dsn-on-64-bit-windo...

Thanks for your comments and for the interest in MySQL software.
Closing the bug.

I experienced same issue.  Backed it down to 5.1.8 and all is good.