MySQL Bugs: #20301: The driver does not appear in odbc tabs.

Bug #20301	The driver does not appear in odbc tabs.
Submitted:	6 Jun 2006 17:34	Modified:	20 Jun 2006 11:21
Reporter:	Alex Pavlov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC Documentation	Severity:	S1 (Critical)
Version:	3.51.12	OS:	Windows (Win2003ServerStd R2 x64)
Assigned to:		CPU Architecture:	Any

Description:
The driver for MySQL does not appear in odbc tabs. But installation passes without problems. So I can't use mySQL server.

How to repeat:
Install on the server with described params.

Hi Alex and thanks for your problem report. This is not a bug.
MyODBC 3.51 is 32bit application which, by default, goes into %SystemRoot%\sysWOW64 folder on 64bit windows. The DataSources(ODBC) link in control panel searches for 64bit drivers in %SystemRoot%\system32 folder (silly naming I know...). 
What you have to do is:
  Locate odbcad32.exe in *%SystemRoot%\sysWOW64 folder* (DO NOT use the one in %SystemRoot%\system32 folder pointed to in control panel!)
  Use this program instead of default 64bit version to access MyODBC
  Start it and add MyODBC driver from the list of available drivers

Sorry for inconvinience, this should have been better documented.

I have now added a description of this issue and resolution to the 4.1, 5.0 and 5.1 Connector chapter.

After insatallation on Win XP Prof x64 of MyODBC 3.51 , i'd found that i can't see MyODBC driver in ODBC control pannel too. Folowing information on page above, 
i found odbcad32.exe in SysWOW64 folder, and was successful adding two data sources, but still i have two problems:

1. first, every time i try to add/change myODBC data sources configuration, the following error appear:" This application uses CTL3D32.DLL, which has not been correctly installed. CTL3D32.DLL must be installed in the Windows system directory." But the mentioned file could be found both in SysWOW64 and System32 folders. After pressing OK button, i can update and save data source properties.

2. Create new empty database using MS Access. When I tried to make new link to table using myODBC data source created in p.1, (following the instructions in "24.1.4.4. Using Connector/ODBC with Microsoft" Access chapter) MS Access failed with error. Nevertheless, i had data base with table-links (via myODBC) created on the same PC, but under Windows XP 32-bit edition, and all tables work well.

So, i can use MyODBC data sources, but i have to use another PC running under Win XP 32-bit edition, to alter table links via myODBC data source.

Hi Team,

I've tried below steps but i'm not getting any option to add MySQL ODBC 5.1 Driver.Please help

What you have to do is:
  Locate odbcad32.exe in *%SystemRoot%\sysWOW64 folder* (DO NOT use the one in %SystemRoot%\system32 folder pointed to in control panel!)
  Use this program instead of default 64bit version to access MyODBC
  Start it and add MyODBC driver from the list of available drivers