Skip to Content
0
Former Member
Aug 24, 2011 at 08:49 PM

CR for VS2010: Failed to Open Connection [Database Vendor Code: 17 ]

697 Views

About once a week for the past 3 weeks, we are getting the following error. Now, this week, it is happening about once a day. Our architecture is we have a Winform client that is hitting a remoting server that is located on our database server. The remoting server uses Crystal Reports to export items to PDF and either store them or return the byte[] to the client. We have received this error twice now in the last 3 weeks and now about 3 times this week.

1. First time we tried just to restart our remoting service, did not fix it. We rebooted and it started working again.

2. Second time we uninstalled Crystal Reports for VS 2010 and installed the Service Pack 1 update. Again we rebooted and it started working.

3. The last few times a reboot worked.

This solution has been in place for months but we have recently added a couple new reports. But once this error starts, it will not go away and no crystal report will work. We dispose of all crystal objects on each call. My problem is why a reboot fixes this? Are we hitting some limit in the free version? Max concurrent threads? I read in one of your documents that only 3 reports run at any given time and then the others are queued. If this is the problem, what is the solution??

Message: Message: Failed to open the connection.

Details: [Database Vendor Code: 17 ]

Failed to open the connection.

SeveranceTaxOklahomaBmp {88F3FD7F-02DC-4958-83F3-A120907104DA}.rpt

Details: [Database Vendor Code: 17 ]

Stack Trace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)

at Seminole.Gem.Reporting.CrystalReports.BaseReport.RunPdfReport() in d:\GemAdmin\SeminoleScrum2010\Production\GEM\Source\Seminole.Gem\Seminole.Gem.Reporting\Seminole.Gem.Reporting\CrystalReports\BaseReport.cs:line 131

Inner Exception: Message: Failed to open the connection.

Details: [Database Vendor Code: 17 ]

Failed to open the connection.

SeveranceTaxOklahomaBmp {88F3FD7F-02DC-4958-83F3-A120907104DA}.rpt

Details: [Database Vendor Code: 17 ]

Stack Trace: at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)