If you want to use MySQL with Lotus Notes and ODBC on your development machine (Windows) it seems that the latest ODBC drivers (5.x) from MySQL often do not work. I have had more success with the older version (3.5.1).
You can install both versions.