mysql ODBC does not connect on win server 2016

Hello Experts
I have installed a MYSQL database on a windows server 2016
also installed MYSQL WORKBENCH and MySQL odbc DRIVERS

The database and the workbench module work just fine...

But when trying to connect our legacy application to the server
it does not work!

We have another separate LAN with three WIN 10 pcs
one of the win 10 pc has the same MySQL server and the workbench module
and all works just fine with our legacy application

We need to continue using our legacy app until we receive
the new program that is being developed to replace it.

What are we missing on the windows 2016 server?

Regards,
RGuillermoProject ManagerAsked:
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.

Dave BaldwinFixer of ProblemsCommented:
Where is the legacy app running from?  The same computer or a remote one?  Is the MySQL version the same in both cases?
0
RGuillermoProject ManagerAuthor Commented:
the legacy app is working from stations in the same LAN not more than 30 meters away.
yes MYSQL version is the same in both
0
Dave BaldwinFixer of ProblemsCommented:
Have you checked the firewall to make sure it can be accessed remotely?  And that the user has '%' (anyhost) permission in the new server?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

RGuillermoProject ManagerAuthor Commented:
Dave,
There is no remote connection. Only from the local network, five computers should be able to access the MYSQL on the win 2016 server.
But we cant connect it...

yes the is "anyhost" permission granted in the new server

I have noticed that on the older LAN the MYSQL ODBC uses platform 32/64 bit and its version 5.3

but in the new LAN, the platform is only 64 bit and its version 8.0

Could this be the problem and how do I get ODBC 5.3?
cant find it
0
RGuillermoProject ManagerAuthor Commented:
The odbc connection is ok... when testing the ODBC module from its own GUI it is always successful
its only our legacy app that cannot reach the odbc i think, in this second independent LAN.
0
RGuillermoProject ManagerAuthor Commented:
Is it possible the active directory is blocking it
in this win server 2016 ?
0
Dave BaldwinFixer of ProblemsCommented:
There is no remote connection.
If it is not on the same computer, it is a remote connection.

second independent LAN
If the client and server are on separate LANs then they normally will be unable to connect.

The ODBC module is used on the client, not the server.
0
RGuillermoProject ManagerAuthor Commented:
I see,
the client and server are in the same LAN.... so this is called also remote connection... good to learn.

we have another separate LAN that I use to test and all is good there... but there is no contact between LANs

My ODBC is version 8.0 and is installed in the station....and it connects directly but when using the legacy app ... there is no connection

what else can I do?
0
Dave BaldwinFixer of ProblemsCommented:
the client and server are in the same LAN.... so this is called also remote connection
A remote connection is when they are Not on the same machine.  If they are on the same machine, it is a local connection.  This is important in the MySQL user setups because the two types use different methods to connect.

we have another separate LAN that I use to test and all is good there... but there is no contact between LANs
That is normal.

If you go to https://dev.mysql.com/downloads/connector/odbc/ and click on Looking for previous GA versions?, you will see the older versions.  If your legacy application is 32-bit, it may not 'see' the 64-bit connector.
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
RGuillermoProject ManagerAuthor Commented:
ok trying to install an older ODBC version but although I already uninstalled the ODBC 8.0 from the control panel.. somehow it is still working..
i believe these make impossible for the previous version to work...

Is there any way to properly uninstall ODBC 8.0 ?
0
Dave BaldwinFixer of ProblemsCommented:
I imagine you could uninstall it in Program and Features.  However, the older 32-bit ODBC connector should be able to co-exist with the 64-bit.  You will have to find it in the 32-bit ODBC Manager.  I don't have Win 10 so I'm not sure where you find that.
0
RGuillermoProject ManagerAuthor Commented:
Thank you so much, it was all fixed by uninstalling all odbc conections in both ODBC32 and ODBC64 then installing ODBC 32 bit
1
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
Windows Server 2016

From novice to tech pro — start learning today.

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.