Configuring ODBC for MySql on Server 2008

We have a database in MySql running on a Server 2003. We are configuring a new machine with Server 2008 (64) for use as a TS server. The problem is that we are not able to create an ODBC server for this new access to the database in 2003 or 64 with driver or with driver 32 (not the DB name appears on the screen to create the ODBC). I would like to help.
Emilio MorimotoProgramadorAsked:
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.

Irwin SantosComputer Integration SpecialistCommented:
Tomas Helgi JohannssonDatabase Administrator / Software EngineerCommented:
          Hi!

If you are running a 32 bit MySQL server on a 64 bit Win2003 and you don't see the ODBC drivers then you are probably looking at the wrong ODBC config.
Try opening/running the ODBCAD32.exe in C:\Windows\SysWOW64 instead of C:\Windows\System32

Hope this helps.

Regards,
    Tomas Helgi
Emilio MorimotoProgramadorAuthor Commented:
Maybe my question has not been clear (my native language is Portuguese). The MySql is installed on a server with 2003, 32, and it is functional. The problem lies in creating ODBC from another server, 2008, 64, used as a TS server, which can not recognize the database server installed in 2003.
Thank you for your help.
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Tomas Helgi JohannssonDatabase Administrator / Software EngineerCommented:
         Hi!

Found this  http://bugs.mysql.com/bug.php?id=56233

Regards,
    Tomas Helgi
Tomas Helgi JohannssonDatabase Administrator / Software EngineerCommented:
And http://bugs.mysql.com/bug.php?id=34769

Regards,
    Tomas Helgi
Emilio MorimotoProgramadorAuthor Commented:
Portuguese to English translation

The above instructions helped me to install / configure the MySQL server in 2008. But the problem remains: I can not configure an ODBC server in 2008 (64) to access the database on the server 2003 (32)

" As instruções acima me ajudaram a instalar / configurar o MySql no server 2008. Mas o problema continua: não consigo configurar um ODBC no server 2008 (64) acessar o banco de dados no server 2003 ( 32 ) "
Emilio MorimotoProgramadorAuthor Commented:

Portuguese to English translation

We disable the Firewall in Server 2003 and can connect normally. Thank you all.

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
Darius GhassemCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
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.