Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

I'm working on an installer that installs a program to a local machine which accesses a remote MySQL database. What I would like to know is, how closely do I need match the ODBC drivers (myodbc.dll) to the MySQL Server version?

Some of our clients have MySQL Server 3.x and some have 5.x, and I would like the installer to get the Server version and then find the matching driver and install it. Will one driver work for multiple Server versions? Or should I just hard-code a bunch of Server-Driver pairings?

share|improve this question
You are still running 3.x? Isn't that way beyond end of life? – Zoredache Jan 27 '12 at 5:39
We aren't running it, but some of our clients are stubborn and won't upgrade: "Because if it works why change?". – Aaron Jan 30 '12 at 15:55

1 Answer

up vote 1 down vote accepted

The biggest change in the mysql client server protocol happened during the changed during the 4.1.1 release. Clients before 4.1.1 will not be able to connect to newer servers.

There certainly are some issues with certain driver pairings. If you are going to continue using ancient unsupported versions in the 3.x series, I suspect you will have issues, and you will probably have to perform internal testing. I am not aware, and cannot find anyone testing this and publishing their results.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.