RSS
 

Installing MyODBC 3.51 on Windows 7 x64

16 Nov

mysql2In order to get some of our 32 bit applications working on Windows 7 64 bit edition, we need to provide support for the MySQL 3.51 ODBC connector.

This is actually quite simple to do, as long as you know what to look for. The ODBC manager that you are able to access from within Windows is not going to work for you, but it turns out that Microsoft provide a 32 bit manager that will.

To use this manager, run the following command:

c:\windows\syswow64\odbcad32.exe

Please note that it is not good enough to just type odbcad32.exe, as there is another file in the path with the same file name (great work MS!). However, once you have opened this application up, it works in the exact same way as if you were running XP.

  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • MySpace
  • Twitter
  • RSS
  • StumbleUpon
 

Tags: , , , , ,

Leave a Reply

 
 
  1. Alan

    April 22, 2010 at 11:23 pm

    I found this page very helpful. I was trying to connect to an existing mysql server on my new windows 7 box and this suggestion fixed me right up. Thanks

     
  2. kira

    May 6, 2010 at 1:31 am

    Thank you!! Searched everywhere before I found this and it cleared up the problem.

     
  3. Marc

    May 6, 2010 at 9:39 am

    Thanks, finally the connections for Business Objects work for Mysql on a Windows 7 x64

     
  4. Àngel

    May 6, 2010 at 1:15 pm

    Incredible…

    Thanks a lot.

    Àngel

     
  5. Sugie

    May 12, 2010 at 4:35 am

    Greatt!!!,
    I downloaded it and it Works like a miracle hahahahahaha,
    thanks very much ^^

     
  6. Ray

    May 12, 2010 at 6:59 pm

    Thanks a lot, you really saved my butt with this !!!!!

     
  7. Neo

    June 2, 2010 at 1:00 pm

    Thanks a lot. Your solution really help me to escape from hell

     
  8. Marcos Cavali

    June 4, 2010 at 7:49 pm

    Wow! Thank you for helping in this, because it was too complex
    for me. Congratulations!
    The connection is successful!

     
  9. Cindy D.

    June 11, 2010 at 3:36 pm

    Excellent resource. Thanks
    Windows 7 (64 bit) PC, also tried the mysql-connector-odbc-5.1.6-winx64.msi would not install. The mysql-connector-odbc-5.1.6-winx32.msi worked. However the ODBC Data Source Administrator does not show the connector under the User DSN or the System DSN. When you run the 32 bit manager it is a source.

     
  10. Sam

    June 30, 2010 at 9:33 am

    Thanks to everyone for leaving comments. Good to know that I’ve helped. We thought we might have to re-write quite a bit of our code before we worked it out. Easy when you know how!

     
  11. Sasa

    July 19, 2010 at 5:51 pm

    e.x.t.r.a!!!!!!!!!!

     
  12. Ashwin Raj

    July 26, 2010 at 4:47 pm

    This did not work for me. I am not sure what I did wrong….

    I installed MySQL ODBC 3.51 driver (using the x86, 64-bit ZIP download). At first, I could not install with the command “install 0″ and then I figured out it was because I had to run it as an Administrator. It seems to copy 8 files (myodbc*.*) to the %windir%\syswow64 and %windir%\system32 folders. As soon as this was done, I invoked the ODBC Manager referred in this article. The Manager came up but it does not list the MySQL ODBC 3.51 driver. When I start up the ODBC Manager from Administrative Tools, it displays the MySQL driver. I did set up the data source, but my application cannot find it. So that’s how I concluded something is quite not right.

    Please help.

    Thanks,
    Ashwin

     
  13. Sam

    July 26, 2010 at 5:02 pm

    Hi Ashwin,

    I haven’t encountered a problem like this before. All that was necessary (during all of the installs I have done since I wrote this article) was just double clicking the MSI to install the software. Admin rights are required, but once the install is finished, I think the article method is still correct.

    However, I was using the 32 bit installer, as the 64 bit installer was not suitable for our software (at the time). I suspect that this is reason it appears in the 64 bit ODBC manager and not in the specified one.

    Are you able to use the 64 bit version? If not, uninstall it, download the 32 bit version and follow the guide… hopefully that will get you on your way!

    Good luck.

    Sam