Crystal Report not connecting to MySQL

[Cimperiali]

DGlienna told you: you might not have MySQL driver.
have a look here:
http://www.mysql.com/products/connector/

By the way: you might have a matter between 64 and 32 bit: if you have the 32 bit of driver, you must compile x86
while you have the 64 bit dirver, you must compile for anycpu (x64) to make it work on your machine. I do believe you can not install both x64 and x32 drivers of mySql on same machine.
about this, have a look here:
http://bugs.mysql.com/bug.php?id=25259

you might not have set up the correct connection string
have a look here
http://www.connectionstrings.com/mysql

you might have a matter of login (username and password)

the fourth problem I was not able to see (unless it was the x32 and x64 matter) but:

User ID: sms
Password: sms
Database: sms

same db name, same username? PPassword is a matter of yours, but I do not like same dbName and same Username...