Thank you for your post.
From your description, this should work. The only thing that I would verify is that you are using MySQL Connector/ODBC version 3.51.14. This is the supported driver for Windows. See Knowledge Base Article #6420 for more information.
Any other information you can provide about the data being linked may be helpful. That is, field type, field contents, etc.