visual studio 2010 - Connecting MySQL with Crystal Reports v10

Question

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 creating 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

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