I’m trying to create VB.Net app with crystal reports and MySQL as the database. I tried connecting Crystal report and MySQL database through various available methods but only DSN method got successful(Partially).

I have created a 64bit System DSN and linked that to crystal report in VB.Net 2022. In the design view, I can see the report with data.

However, when I try to run and view the report, following happens.

1. Crystal report again asks for the login credentials.
   
2. Get a “Logon failure” error even after giving the correct credentials.
   

I also set the logon credentials at the run time using following code.

   Dim rep As New crRepAllBooks
   rep.SetDatabaseLogon("root", "xxxxxxxxx", "localhost", "lms")
   CrystalReportViewer1.ReportSource = rep
   rep.Refresh()

Can some one explain me how to do this properly without getting the prompt to enter credentials.