Register Login Search New Posts Chat

	Iron Speed > Forums > Code Customizations V6.X > Crystal Reports in IS 6.2 Pro	Username:   Password:        Remember Me?

Thread Tools Search This Thread

Reply

Author Comment

View Member ProfileFind Member's Threads Find Member's Posts akaeser Registered: 10/08/09 Posts: 31

10/26/09 at 12:16 PM Reply with quote #1 I am using 6.2 Pro. I created a Crystal Report in VS 2008. It views without an issue in VS 2008. It is called from a button on my show Sales Order page using the instructions I found on how to display a CR in a PDF. I added the 3 CrystalDecision references in VS as required. I add 3 import statements on the sales order control page (One for each of the previous references). Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports CrystalDecisions.ReportSource This is what I get returned when trying to run the report from the button. This is a SQL 2000 database running on my remote server that I am VPN'ed to. Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Communication link failure SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: TCP Provider: An existing connection was forcibly closed by the remote host. SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'DNN'. SQL State: 28000 Native Error: Error in File C:\DOCUME~1\akaeser\LOCALS~1\Temp\Invoice {5A3802D9-840A-41DD-AB86-B4862B606906}.rpt: Unable to connect: incorrect log on parameters. 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: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Communication link failure SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: TCP Provider: An existing connection was forcibly closed by the remote host. SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'DNN'. SQL State: 28000 Native Error: Error in File C:\DOCUME~1\akaeser\LOCALS~1\Temp\Invoice {5A3802D9-840A-41DD-AB86-B4862B606906}.rpt: Unable to connect: incorrect log on parameters. Source Error: Line 126: Line 127:    ' Export the document to the temporary file. Line 128:    reportObject.Export() Line 129: Line 130:    ' Create the HTTP Response as PDF and output the file. Source File: C:\GESalesOrder\App_Code\TblGESalesOrder\ShowTblGESalesOrder.Controls.vb    Line: 128 Stack Trace: [COMException (0x8004100f): Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Communication link failure SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: TCP Provider: An existing connection was forcibly closed by the remote host. SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'DNN'. SQL State: 28000 Native Error: Error in File C:\DOCUME~1\akaeser\LOCALS~1\Temp\Invoice {5A3802D9-840A-41DD-AB86-B4862B606906}.rpt: Unable to connect: incorrect log on parameters.]    CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) +0    CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +240 [LogOnException: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Communication link failure SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: TCP Provider: An existing connection was forcibly closed by the remote host. SQL State: 08S01 Native Error: Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'DNN'. SQL State: 28000 Native Error: Error in File C:\DOCUME~1\akaeser\LOCALS~1\Temp\Invoice {5A3802D9-840A-41DD-AB86-B4862B606906}.rpt: Unable to connect: incorrect log on parameters.]    CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +280    CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +295    CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) +646    CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) +206    CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() +68    CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() +64    GESales.UI.Controls.ShowTblGESalesOrder.TblGESalesOrderRecordControl.DisplayReportAsPDF(ReportDocument reportObject) in C:\GESalesOrder\App_Code\TblGESalesOrder\ShowTblGESalesOrder.Controls.vb:128    GESales.UI.Controls.ShowTblGESalesOrder.TblGESalesOrderRecordControl.Button_Click(Object sender, EventArgs args) in C:\GESalesOrder\App_Code\TblGESalesOrder\ShowTblGESalesOrder.Controls.vb:86    System.EventHandler.Invoke(Object sender, EventArgs e) +0    System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +111    System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +79    System.Web.UI.WebControls.LinkButton.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) +175    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082 I am aware that IS Enterprise has native support for Crystal Reports, but that may not be an option for me at this time. I have viewed most of the knowledgebase, and help file articles to resolve this. Have I missed something in my deployment? Loading...

Previous Thread | Next Thread

Reply

Bookmarks

Digg  del.icio.us  StumbleUpon  Google