Crystal Report not connecting to MySQL

[fade.26]

My Project is successfully running,. it can even load the data onto my tables from MySQL database
but the problem is,. when i open my reports which is CrystalReport based,. it prompts for a Database Login,. I am using Windows 7 64bit and Visual Basic 2008 with the latest MySQL Server.

On my CrystalReport1.rpt when i click the Main Report Preview,.
ODBC (RDO) pops up asking for Data Source Selection,. i tried filling up the connection String with:

"DRIVER={MySQL ODBC 3.51 Driver};DATABASE=sms;OPTION=3; SERVER=localhost;UID=sms;PWD=sms;"

still, it asks for Connection Information
I inputted
Server: localhost
User ID: sms
Password: sms
Database: sms

when i click Finish,. there is an error telling,.

Logon Failed.
Details: IM002:[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

[dglienna]

It's telling you 4 things, but start by searching for these:

Data Source name not found

And also:

No default driver specified

[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...