Loading

CrystalReport Error

CrystalReport Error

Narayana

10y989.NET

OracleCommand cmd = new OracleCommand(qry, db.Con);

OracleDataAdapter da = new OracleDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

ReportDocument Report = new ReportDocument();

Report.Load(Server.MapPath("~/Reports/Example.rpt"));

Report.SetDataSource(ds);

Report.SetParameterValue("Company", AppSettings.Company);

Report.SetParameterValue("Add1", AppSettings.Add1);

Report.SetParameterValue("Add2", AppSettings.Add2);

CrystalReportViewer1.ReportSource = auditReport;

CrystalReportViewer1.DataBind();

Error Message:

Error

Failed to open the connection. Details: [Database Vendor Code: 12154 ]

Please Clarify With Detail Coding because I am new in Crystal Report.

2 Replies

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

Narayana9y ago
OracleCommand cmd = new OracleCommand(qry, db.Con);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("Party_Address_Labels.rpt"));
report.DataSourceConnections.Clear();
report.Database.Tables[0].SetDataSource(ds.Tables[0]);
report.Refresh();
Report.SetParameterValue("Company", AppSettings.Company);
Report.SetParameterValue("Add1", AppSettings.Add1);
Report.SetParameterValue("Add2", AppSettings.Add2);
CrystalReportViewer1.ReportSource = auditReport;
CrystalReportViewer1.DataBind();

I am resolving this issue, just changing one line.
Nilesh Jadav10y ago
Well that might be the compatibility issues of crystal report or your database server.
Refer this two link to make out your solution :

1) https://scn.sap.com/thread/1828158

2) http://scn.sap.com/thread/3176845b

I guess you have to install the patch for this :

Fix this by installing the latest Oracle 32 bit client (10.2.0.3.0). It seems like 32 bit client 10.2.0.1.0 is not compatible with Windows server 2008 64bit. (Source : From the above link)

Hope that might help you !