Connecting MySQL with Crystal Reports v10

I am new to Crystal Reports v10 and I'm creating reports to embed in Visual Studio 2010 forms. The database server I'm using is MySQL. I have some issues regarding to creat开发者_如何转开发ing new connection in crystal reports. Based on what I've read, I should select the ODBC in order for me to connect it to the MySQL. However, when I select ODBC and LocalServer and enter the username and password an error message occurred and shows Logon Failed. Am I doing it right? Is there anything you could help me please?

I already installed the MySQL Connector/ODBC 5.1

You need to install the MySQL ODBC Connector.. Create an ODBC data source from the Administrative Tools \ ODBC Data sources control panel. It will then be available in Crystal Reports.

You must download the appropriate version of mysql odbc connector since there are two of them:

1. mysql odbc connector Windows (x86, 32-bit), MSI Installer)
2. mysql odbc connector Windows (x86, 64-bit), MSI Installer)

if 64-bit doesn't run, try to uninstall it and try the 32 bit msi Installer

http://dev.mysql.com/downloads/connector/net/