CODEWITHSUNDEEP
mysqlvb.netcrystal-reports
Lee Song
Lee Song

Reputation: 83

How to connect Crystal Report and MySQL in VB.NET

To clarify things first, I can connect MySQL to VB.NET. But I can't connect Crystal Report and MySQL. When I'm creating new report in CrystalReportViewer control, I am stucked at the Standard Report Creation Wizard window. I can't see any connections and my database (I created it in MySQL Query Browser).

I'm using: Visual Studio 2010enter image description here, MySQL Query Browser, SQL Server 2005, Crystal Report(CRforVS13_0_13)

Any help? Or am I just missing something?

Upvotes: 1

Views: 9255

Answers (1)

Rohit Gupta
Rohit Gupta

Reputation: 4191

Crystal Report requires an ODBC driver. You can find one here.

After you have installed it, check that it exists in the ODBC Data Sources.

It must be visible here. When I get home, I can instal it and show you hat the text looks like.

Once there, you need to create an Alias. Click on the User DSN tab and press the Add button. Test the connection then go to Crystal reports.

Upvotes: 1

Related Questions