I have a bunch of reports I run at the end of every month, from my windows 7 workstation. We have a Linux box running MySQL.
We are running the ODBC 3.51 connector from Microsoft Excel 2007. I upgraded my workstation from Windows 7 32 bit, to Windows 7 64 bit. I copied my spreadsheets over to the new cpu. Now when I try to edit a spreadsheet query, I get the following error.
[MySQL][ODBC 3.51 Driver] Could not find the driver "c:\program files\mysqConnector ODBC 3.51\myodbc3.dll" in system information.
I have checked, and the file is in the correct location. I think it has to do with upgrading to 64 bit. I can recreate all the spreadsheets, but that is a lot of work. Do I have to re-register a dll, or is there a registry enter that I can change without having to rebuild every thing.
Thanks for your help.