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 19:34	Modified:	20 Jun 2006 13:21
Reporter:	Alex Pavlov
Status:	Closed
Category:	Connector/ODBC: Docs	Severity:	S1 (Critical)
Version:	3.51.12	OS:	Microsoft Windows (Win2003ServerStd R2 x64)
Assigned to:		Target Version:
Triage:	D4 (Minor)

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.