Getting the error for Report

Debasis Mohapatra

Hi,

I am getting the report after click on print button. i have installed te crystal report version

the error below

Error

Failed to open the connection. ProformaInvoice 9908_20416_{DFFD5BF1-A205-4E33-9292-93B15005D4FC}.rpt Details: [Database Vendor Code: 17 ]

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Debasis Mohapatra7y ago
Hi Kalyani,

I have solved it acctualy the connection has not done properly with the sql server that's why the error was happening. now the report is displaying properly.
Debasis Mohapatra7y ago
Thank you Shevale for your reply, but i have done in the same way can you please check my below code. In webconfigi have checked all is correct. why the error is happening.

private void printdocument(string inno)

{

ReportDocument rpp = null;

try

{

rpp = new ReportDocument();

string pathh = Server.MapPath("..\\Upload");

string totalPAth = Server.MapPath("ProductionOrder.rpt");

rpp.Load(totalPAth);

rpp.SetParameterValue("docno", inno);

rpp.SetParameterValue("pathh", pathh);

CrystalReportViewer1.ReportSource = rpp;

CrystalReportViewer1.DataBind();

SetCRLogOnInfo(rpp, @"SDF-WS", "sa", "abcd-1234", "DBBJBPL1");

}

catch (Exception ex)

{

}

finally

{

}

}

public void SetCRLogOnInfo(ReportDocument mainInRD, string dataSource, string userId, string pwd, string database)

{

//do the main reports database

TableLogOnInfo logonInfo = null;

foreach (CrystalDecisions.CrystalReports.Engine.Table table in mainInRD.Database.Tables)

{

logonInfo = table.LogOnInfo;

logonInfo.ConnectionInfo.ServerName = dataSource;

logonInfo.ConnectionInfo.DatabaseName = database;

logonInfo.ConnectionInfo.UserID = userId;

logonInfo.ConnectionInfo.Password = pwd;

table.ApplyLogOnInfo(logonInfo);

}

try

{

//now update logon info for all sub-reports

if (!mainInRD.IsSubreport && mainInRD.Subreports != null && mainInRD.Subreports.Count > 0)

{

foreach (ReportDocument rd in mainInRD.Subreports)

{

SetCRLogOnInfo(rd, dataSource, userId, pwd, database);

}

}

}

catch

{

}

}
Kalyani Shevale7y ago
refer below Link

https://apps.support.sap.com/sap/support/knowledge/public/en/1676673
https://archive.sap.com/discussions/thread/3945873
https://medium.com/@satawneh/crystal-reports-failed-to-open-connection-code-17-2f4176f169af
https://www.codeproject.com/questions/667950/crystal-reports-connection-to-sql-server-database