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?