sql queries no longer work after upgrading to windows 7 64bit.

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.
LVL 1
Steven BlackAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
mysqConnector ODBC 3.51 is a fairly old connector.  At the very least, it would have to be re-installed.  At the most, replaced with a newer version.  The current ODBC connector is here http://dev.mysql.com/downloads/connector/odbc/ in both 32-bit and 64-bit versions.
0
Steven BlackAuthor Commented:
I know the connector is very old. The vendor of our POS, Inventory, accounting system, requires that connector. I don't know why, other than they may be using an older version of MySQL, and don't want to update it. I have downloaded the newest version of the connector that I could find. I have installed it twice and verified all the settings, but the problem continues. I have found I can open everything on the old system and copy the SQL code to a new file on the new machine and it works. Just a bunch of extra time at this point.
0
Dave BaldwinFixer of ProblemsCommented:
You can have more than one version of the ODBC connector on your machine at the same time.  I have both 3.51 and 5.1 and they do not interfere with each other.  Only the on that you specify operates at any given time.  I suggest you download and install the new version and try it.

You did look in your ODBC manager and verify that ODBC 3.51 is there?  Of course there are two ODBC managers on Win64.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Steven BlackAuthor Commented:
Yes, I have looked at the manager. The connector does in fact work. If I create a new spreadsheet, all is fine. It is only when I try to use a spreadsheet I built on the older computer that I have a problem.
0
Dave BaldwinFixer of ProblemsCommented:
Then the problem is not actually the connector but something in the old spreadsheets.  Try redoing the connection in them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steven BlackAuthor Commented:
I have found the answer. I went to the Data tab, then connections. Under connection properties, I went to the connection definition tab. The user name was different on the new connector then what was used on the old connector. I changed the name to match the new connector, and all worked.

Thanks for the help Dave.
0
Dave BaldwinFixer of ProblemsCommented:
You're welcome!  I suspect that will happen anytime you move it to a different computer?
0
Steven BlackAuthor Commented:
It would if you changed the user name in the connector, since that is stored with each spreadsheet. It is a much easier fix that creating everything from scratch. I would imagine that if any of the parameters in the connector change, it would do the same thing.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.