When trying to connect to MySQL using VB6, the error “Data source name not found and no default driver specified” occured.
After searching the internet for possible reason and solution, i found the solution below and it works like magic!
First you need to download the MySQL Connector/ODBC here. I downloaded the mysql-connector-odbc-5.1.13-win32.msi since my OS is Windows XP. Second, install it!
Third, run your program again and check if the error will still occur.
Let me know if you encounter problem or you have question about it.