I am trying to install a MySQL connector on a Windows 7 system, but it does not appear in the add ODBC window

Question

This is under the 64-bit version of Windows 7. I downloaded 64-bit drivers, and in fact I tried all the Windows drivers (although I removed the previous ones first). But when I try to configure a new ODBC connection, the MySQL driver does not appear.

Do I need to install any other package before I can get the connector to work? Like MDAC or .NET or something else?

Answer 1

Try running ODBC from "C: \ Windows \ SysWOW64" instead of "C: \ Windows \ System32".

Answer 2

The key question is whether the ODBC client executable is a thing to download a driver library and use data - 32-bit or 64-bit. The 64-bit version of Windows (XP, Vista, 7, 8, Server 2003, Server 2008 and all other options) supports both 32-bit and 64-bit executables / libraries. 32-bit executables (usually found in Program Files (x86) ) can only use 32-bit drivers; 64-bit executables (usually found in Program Files ) can only use 64-bit drivers.

Once you understand this part, you need to install the appropriate 32-bit or 64-bit driver for MySQL and configure it using the correct ODBC administrator. The 32-bit ODBC administrator is encountered in C:\Windows\SysWow64\odbcad32.exe , and the 64-bit ODBC administrator is found in C:\Windows\System32\odbcad32.exe . (Yes, they are both called odbcad32 , and the directory names point to another bit - but what I just said is accurate.)

For more on this, you can read the article published on my employer website.

Note that for added pleasure, the Microsoft ODBC Driver Manager (MDAC) has the error that it shows 32-bit user DSNs for 64-bit client executables (including Administrator), and it shows 64-bit user DSN files for 32 -bit executable files of the client (again, including the Administrator) - although these incorrect matches cannot work together. For this reason, I highly recommend using only system DSNs in any environment that may contain a combination of 32-bit and 64-bit executables / drivers / DSNs.

Answer 3

If you want to run 32 bits in WIN 7: Download the 32-bit version of ZIP (fe mysql-connector-odbc-noinstall-5.1.13-win32) Run Install.bat Open c: \ Windows \ SysWow64 \ odbcad32.exe in User DSN Add and you can choose from 32-bit drivers

Answer 4

"The 32-bit administrator is found in SysWow64, and the 64-bit IS administrator is found in System32. - TallTed May 5 '14 at 16:19."

So, I ended the hellish week following the simple statement of Ted. I discovered this well-hidden 32-bit version and Wah La! All the drivers that I still haven’t seen were ready and ready to go to work. They even survived several crazy uninstallations!

I am on an iMac running Windows 7 Ultimate on Parallels 10. The MS Access application was built on a Win7-only machine that I was able to associate with MySQL thanks to a random set of monkey tools. I was not lucky on this machine. If Ted factoid works on this IMac, it will work anywhere.

btw: It turns out I have both 32-bit and 64-bit drivers, Unicode, etc. - all three. I am not ready to figure it out .: 0

Answer 5

Access to 2013 will not be displayed until I installed both 32-bit and 64-bit drivers, and then exited and restarted Access.