Attempting to install 32 bit mysql odbc driver on a 64 bit machine

I have a 64 bit windows machine that needs to connect to a 32 bit windows machine running mysql using odbc (OS on both machines is windows 7). I tried installing the 32 bit mysql connector odbc driver on the windows machine, but the registry entries for the new driver don't get created by the installer. Do I just need to add the odbc registry entries manually?
opikeAsked:
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.

markloganCommented:
What happened when you tried the 64bit driver on the 64bit machine?

We have MySQL running on a 64bit Linux box and a mixture of 32bit and 64bit Windows machines connecting using the ODBC driver.
0
opikeAuthor Commented:
The 64bit driver wont connect to the MySQL instance running on the 32 bit machine.
0
markloganCommented:
How can you tell? What is the error message is it returning?

Permission denied?
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.

yogi4lifeCommented:
I don't think there are any reason to use 32-bit ODBC drivers on your 64-bit machine... The fact that your server is 32-bit should be transparent to the ODBC-clients... Try to use a 64-bit ODBC drivers...
0
opikeAuthor Commented:
It gave an error message with something about "mismatched architecture". I'll have to go back and install the 64 bit driver to get the exact wording.

The reason I can tell that the 64 bit driver wasn't connecting to the 32 bit instance was because at that point I only had the 64 bit driver installed.
0
markloganCommented:
The specified DSN contains an architecture mismatch between the Driver and Application ?

0
opikeAuthor Commented:
I ended up going with the jdbc driver.
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
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.