MySQL Bugs: #12255: My ODBC Driver Installer works but Driver is not Loaded in XP64

Bug #12255	My ODBC Driver Installer works but Driver is not Loaded in XP64
Submitted:	29 Jul 2005 1:37	Modified:	24 Oct 2005 18:19
Reporter:	Surinder Mastana	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	MyODBC 3.51.11-2	OS:	Windows (Windows XP64 Bit)
Assigned to:		CPU Architecture:	Any

Description:
On Windows XP 64 bit Edition, MySql works fine but MyODBC driver does not show in ODBC Data Sources.

How to repeat:
Load XP 64Bit (Release Version)
Load MyODBC ...and notice it dont load the driver.

Suggested fix:
Dont have one....

Could you please say your actions step by step when you are installing ODBC driver ?

Ok Here it is ... 

1) Download the driver

2) Ran the installation

3) IT did not have any errors

4) Can't find the driver in the ODBC Sources

5) Can't find the driver in the Registry (as oppsed to a standard installtion in XP Pro

6) Followed with manually entering the driver into the registry and saw the driver in the ODBC Source but cound not create a System DSN  - got two errors ...see attached screen shots scrsh1.gif & scrch2.gif

7) Downloaded source and compiled the driver all ok but could not load the driver ....myodbcinst>myodbcinst.exe -q -s -n"MySQL ODBC 3
.51 Driver"
[myodbcinst.c][478][WARNING] Could not load (MySQL ODBC 3.51 Driver)

8) after manually entring the driver in the registry got this
C:\MyODBC-3.51.11\MyODBC-3.51.11\myodbcinst>myodbcinst.exe -a -d -t"MySQL ODBC 3
.51 Driver;DRIVER=c:\windows\system32\myodbc3.dll;SETUP=c:\windows\system32\myod
bc3S.dll"
[myodbcinst.c][611][INFO] Driver registered. Usage count is 8. Location "C:\WIND
OWS\system32\"

C:\MyODBC-3.51.11\MyODBC-3.51.11\myodbcinst>myodbcinst.exe -q -s -n"MySQL ODBC 3
.51 Driver"
[myodbcinst.c][478][WARNING] Could not load (MySQL ODBC 3.51 Driver)

9) I have attached one other screen shot for you .

Please note this is a Windows XP 64 Bit Edition (Release version) fully patched.
And WinXP64 has another system directory (i think)  c:\windows\syswow64

plus we also tried to install it to /syswow64 directory and pointing the drivers there....driver still don't load.

Please help we really need the ODBC working on the 64 bit machine....

Thannks
Surinder

Screen Shot One

Attachment: scrsh1.gif (image/gif, text), 51.46 KiB.

Sreen Shot Two

Attachment: scrsh2.gif (image/gif, text), 50.89 KiB.

Screen Shot Three

Attachment: scrsh3.gif (image/gif, text), 56.39 KiB.

Thanks for your bug report.  I was able to reproduce this under WinXP64 - AMD64

OK ...Phew... So i am not the only one having this problem .....Let hope there's a fix soon!  
Cheers!
Surinder Mastana

I have tested c/odbc v3.51.12 on XP Pro 64bit and made the following observations.

- it installs fine (into syswow64)
- ODBC Administrator in Control Panel does not show driver - presumably because it is the 64bit ODBC Administrator and is only showing 64bit drivers
- 32bit ODBC Administrator (as found in syswow64) does show the driver

I did not do further testing it seems to install fine from msi. Installing from source is not as likely to succeed - at least not using the provided install tools (myodbc3i.exe and batch files) as these tools do not, currently, account for a 64bit environment.

there is something we are all missing here.  i have cache (intersystems) and sql anywhere installed on this system - both 64 bit versions of the software - their odbc drivers show up in both the 64 bit and 32 bit odbc admins and in fact work with access which is 32 bit.  the odbc for mysql 3.51 works as well (with a fix for msjet40.dll) but is not to be seen in the 64 bit odbc list.  my point here is that for some reason, both sql anywhere and cache install with their drivers showing up in both - is it mapping?  i do not believe they are installing both????

Download the driver for 64 bit system from the following link and try it.
http://dev.mysql.com/downloads/connector/odbc/5.1.html#winx64
it will work fine .

Interesting, here it is 2012 I am having the same issue.  I have downloaded the MySQL driver and created a system DSN.  MySQL works fine, the system DSN is recognized. 

However, even though I have downloaded and reinstalled the MySQL driver, XMLSpy still does not load the driver into the list of available drivers, even when select MySQL from the list of database types.

MySQL Connector/ODBC 5.1.11
XMLSpy Professional Version 2012 sp1

I should not that the above issue is with a laptop running Windows 7.

download an odbc connector which is 64bit.

The reason why it can't find your odbc connector driver is because the connector you installed is just 32 bit.

Check Windows SysWOW64 odbcad32 for the 32 bit odbc