Connecting to MySQL db through ODBC in Access 2010

I used MySQL ODBC 5.1 driver to create a System data source. I tested and all was successful, and the data source shows up in ODBC Data Source Administrator under System DSN. (Actually, I've tried it several times so I should say that all the data sources I've created are listed in ODBC Data Source Administrator under System DSN.)

I want to connect to the data source through Access 2010, but when I get to the list of Machine Data Sources in Access, none of the data sources I created are on the list.  

A friend who is helping me did exactly the same thing on his laptop and the data source was in the list when he went to connect.

My machine is Windows 7 64 bit.

Any ideas what might be happening?
figsageeAsked:
Who is Participating?
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.

danishaniCommented:
0
figsageeAuthor Commented:
I did try that. I would use odbcad32.exe to create the data source, right? I got stuck because I didn't see the MySQL driver on the list of options when I ran odbcad32.exe.
0
danishaniCommented:
That's seems like the way to accomplish it.

Check also below thread, with more detailed steps:
http://www.ajpdsoft.com/modules.php?traducir=es-en&name=News&file=article&sid=573

Hope this helps,
Daniel
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
figsageeAuthor Commented:
That worked! I had to reinstall the MySQL ODBC driver using the instructions at the link you gave. It seemed to be exactly the same way I installed the first time, except I clicked on Custom for installation options. But I didn't change anything! Anyway, after I did that I was able to see the MySQL driver when I ran odbcad32.exe.

Thank you!
0
figsageeAuthor Commented:
Thank you, Daniel!
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
Microsoft Access

From novice to tech pro — start learning today.