Search for this Driver in google.............myodbc-2.50.19-win95.zip if ur OS is win 95/98 else myodbc-2.50.19-NT.zip for NT........I am having the same if u want I can mail it u..........fter installin the driver u can use this con string:

strCnn = "driver={MySQL};Server=ipaddress;" & _
"uid=root;pwd=;database=mydatabase"

hope this will help u..........