• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

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.
0
Steven Black
Asked:
Steven Black
  • 4
  • 4
1 Solution
 
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now