Crystal Report Asking for Login Credentials

Question

Hi, i need very very urgent help. I have developed application with MySql, VS2013, SAP crystal Report 13_0_16 install executable, I use DSN for connecting to mysql. I have install MySql ODBC 3.51.11 connector drivers . I updated few things in the software and suddenly it started asking login credentials. I changed the datasource Location from crystal report. Now its showing correctly on my laptop. As i install on my client laptop it ask for same login credentials. I have installled same things at my client laptop. SO please guide me asap. I need help very urgently. I request you to please place this in correct category if i have choosen wrong category. Thanks in advance.

Vasanth Natarajan · Answer

Hi i think your DSN Connection is Cleared so try this this working for me //DSN Connection Reseted ReportDocument objReportDocument = new ReportDocument(); objReportDocument.Load(strpaths); ConnectionInfo crConnectionInfo = new ConnectionInfo(); crConnectionInfo.LogonProperties.Remove(crConnectionInfo); crConnectionInfo.AllowCustomConnection = true; crConnectionInfo.IntegratedSecurity = true; crConnectionInfo.ServerName = strDSNName; crConnectionInfo.DatabaseName = strDatabase; crConnectionInfo.UserID = strUserName; crConnectionInfo.Password = strPassword; TableLogOnInfo crTableLogoninfo = new TableLogOnInfo(); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in objReportDocument.Database.Tables) { crTableLogoninfo = CrTable.LogOnInfo; crTableLogoninfo.ConnectionInfo = crConnectionInfo; } for (int i = 0; i { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in objReportDocument.Subreports[0].Database.Tables) { crTableLogoninfo = CrTable.LogOnInfo; crTableLogoninfo.ConnectionInfo = crConnectionInfo; } } And export to display the PDF Formate if (objReportDocument.DataSourceConnections.Count > 0) { objReportDocument.DataSourceConnections[0].IntegratedSecurity = false; } for (int i = 0; i { objReportDocument.Subreports[i].DataSourceConnections[0].IntegratedSecurity = false; } crystalReportViewer1.ReportSource = objReportDocument; crystalReportViewer1.RefreshReport(); crystalReportViewer1.Visible = false; objReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, OutputPDFFileName);

Debasis Saha · Answer

It's a common error of Crystal Report. Before going to deployment, open the crystal report in your project and verify the datasource by select the datasource option. It will ask for Datasource. Select the datasource and in deployment check that your datasource file is deployed or not.

Chandan Kumar · Answer

Dear Post Snapshot as well for the better understanding of your Problem. Thanks...

Kedar Pawgi · Answer

Hi all Thank you for your replies. But sorry to say that it was all my mistake. I apologize for this, as the mistake i made was that the name of database in localhost and in client database got changed. So it was asking login details. Sorry again for this and thank for taking time and replying my post. Thanks friends. now just a query how to close this thread. so no one will not reply to this query

Crystal Report Asking for Login Credentials

Answers (4)