asp.net c# ขึ้นserver แล้วเกิด error ช่วยทีค่ะ เกียวกับไฟล์ crytal report ค่ะ (2) ช่วยทีนะค่ะ
Code (C#)
//ReportImpExpCompany ชื่อไฟล์crytalreport ค่ะ
ReportImpExpCompany rpt = new ReportImpExpCompany();
rpt.SetDataSource(ds.Tables["DTImpExpCompany"]);
rpt.SetParameterValue("sc", sc);
rpt.SetParameterValue("ec", ec);
rpt.SetParameterValue("sm", sm);
rpt.SetParameterValue("em", em);
rpt.SetParameterValue("sy", sy);
//Export to PDF
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = Server.MapPath("/Gallery/DataFile/Report.pdf");
CrExportOptions = rpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
rpt.Export();
//PDF
byte[] file = File.ReadAllBytes(Server.MapPath("/Gallery/DataFile/") + "Report.pdf");
MemoryStream ms = new MemoryStream(file);
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Cache-Control", "max-age=3");
Response.AddHeader("Pragma", "public");
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=Report.pdf");
Response.AddHeader("Content-Length", ms.Length.ToString());
Response.BinaryWrite(ms.ToArray());
Response.Flush();
Response.End();
ขึ้นerror นี้ค่ะ ช่วยทีติดนานมากกกกกกกกก
Code
Server Error in '/ReportOnline' Application.
--------------------------------------------------------------------------------
Database logon failed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Database logon failed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x8004100f): Database logon failed.]
CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) +0
CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +260
[LogOnException: Database logon failed.]
CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +280
CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +315
CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) +645
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) +206
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() +68
CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() +64
ReportOverview.Gallery.ValMonth.CRptImpExpValMonth() in D:\CODEWORD_SVN\ ReportOnline\ReportOverview\Gallery\ValMonth.aspx.cs:237
ReportOverview.Gallery.ValMonth.btnOk_Click(Object sender, EventArgs e) in D:\CODEWORD_SVN\ ReportOnline\ReportOverview\Gallery\ValMonth.aspx.cs:134
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3625; ASP.NET Version:2.0.50727.3634
Tag : .NET
Date :
2013-09-10 11:10:07
By :
ิิิbb
View :
1071
Reply :
1
ไม่ Capture หน้าโค้ดมาอ่ะครับ ถ้า Copy พี่ๆ เค้าจะดูไม่รู้เรื่อง
Date :
2013-09-11 09:31:40
By :
Rutsaza
Load balance : Server 01