MySQL Connector for 64bit Windows is loading in wrong Windows Registry Location.

"Hafer, Christopher G" <[email protected]> Tue, 24 Apr 2012 10:46:08 -0400
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <[email protected]>
I am installing on a new Hard Dive for a 64bit Windows 7 workstation.  When=
 I add the x64 MySQL ODBC connector, it gets loaded into the registry for t=
he 32bit ODBC not the 64bit ODBC.  It should be loading into "HKEY_LOCAL_MA=
CHINE/SOFTWARE/Wow6432Node/ODBC/ODBCINST.INI" instead of " HKEY_LOCAL_MACHI=
NE/SOFTWARE/ODBC/ODBCINST.INI"

I understand how 64bit windows systems use the 32bit ODBC as default but I =
am using the "SysWOW64" folder and opening odbcad32.exe and the associated =
registry entries for 64bit drivers vs. 32bit drivers.  =20

This statement is not correct for Windows 7 64bit systems because this x64 =
MySQL connector gets loaded in the 32bit ODBC registry location:=20
"...use the ODBC administration tool located at %SystemRoot%\SysWOW64\odbca=
d32.exe, this will correctly locate the installed Connector/ODBC drivers an=
d enable you to create a Connector/ODBC DSN."

---------- System Information ---------------------
-Connector app Files:=20
mysql-connector-odbc-5.1.10-winx64.msi
mysql-connector-odbc-noinstall-5.1.10-winx64.zip

**Operating system and version**
Windows 7 x64 Enterprise

**Connector/ODBC version**
mysql-connector-odbc-5.1.10-winx64.msi
mysql-connector-odbc-noinstall-5.1.10-winx64.zip

**ODBC Driver Manager type and version**
Windows 7 x64, version 6.1.7601.17514

**MySQL server version**
Non/Applicable=20

**ODBC trace from Driver Manager**
Non/Applicable=20

**Connector/ODBC log file from Connector/ODBC driver**
Non/Applicable

**Simple reproducible sample**
1) Install mysql-connector-odbc-5.1.10-winx64.msi to 64bit Windows 7 system=
.
2) Use -regedit- to view the registry entry for ODBC
3) The 64bit MySQL connector gets added to registry path "HKEY_LOCAL_MACHIN=
E/SOFTWARE/ODBC/ODBCINST.INI" (this is the 32bit ODBC registry entry)

***Entry should get added to registry path "HKEY_LOCAL_MACHINE/SOFTWARE/Wow=
6432Node/ODBC/ODBCINST.INI (this is the 64bit ODBC registry entry)***
=20

----------- OLD Post about similar issue ----------------------
22.1.7.3.1: I have installed Connector/ODBC on Windows XP x64 Edition or Wi=
ndows Server 2003 R2 x64. The installation completed successfully, but the =
Connector/ODBC driver does not appear in ODBC Data Source Administrator.=20
This is not a bug, but is related to the way Windows x64 editions operate w=
ith the ODBC driver. On Windows x64 editions, the Connector/ODBC driver is =
installed in the %SystemRoot%\SysWOW64 folder. However, the default ODBC Da=
ta Source Administrator that is available through the Administrative Tools =
or Control Panel in Windows x64 Editions is located in the %SystemRoot%\sys=
tem32 folder, and only searches this folder for ODBC drivers.=20
On Windows x64 editions, use the ODBC administration tool located at %Syste=
mRoot%\SysWOW64\odbcad32.exe, this will correctly locate the installed Conn=
ector/ODBC drivers and enable you to create a Connector/ODBC DSN.=20
This issue was originally reported as Bug #20301.=20
---------------------------------------------------------------------

Thank you,
Christopher G. Hafer, CPD, CDD
Senior Applications Analyst
[email protected]



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc