Skip to Content
avatar image
Former Member

CR2008:Failed to open the connection. Failed to open the connection.<Report

Hi,

I've just upgraded from Crystal XI R2 to Crystal 2008. All my reports open happily in Crystal 2008. I have also deployed the Crystal 2008 runtime to a Windows 2003 SP2 R2 server running ASP.NET 1 and ASP.NET 2. Before the Crystal 2008 runtime was installed on top of the already present Crystal XI R2 Runtime I could view RPT files via the .NET report viewer (version XI). Now that Crystal 2008 runtime is installed I receive an error message when I try to view the reports, again, via the .NET report viewer (version 12), although no code has changed apart from all references changed from XI to 2008.

Code is:

CrystalDecisions.CrystalReports.Engine.ReportDocument oReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();

oReportDocument.Load(sReportFilename);

Tables oTables = oReportDocument.Database.Tables;

foreach (CrystalDecisions.CrystalReports.Engine.Table oTable in oTables)

{

TableLogOnInfo crTableLogOnInfo = oTable.LogOnInfo;

crTableLogOnInfo.ConnectionInfo.IntegratedSecurity = true;

crTableLogOnInfo.ConnectionInfo.DatabaseName = "DB" ;

crTableLogOnInfo.ConnectionInfo.ServerName = "server" ;

oTable.ApplyLogOnInfo(crTableLogOnInfo);

}

CrystalReportViewer1.ReportSource = oReportDocument;

this.DataBind();

Error message is: 'Failed to open the connection. Failed to open the connection'.

Any help would be great.

Regards

Tony

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 03, 2008 at 02:03 PM

    I assume that the upgraded app works on your development computer(?). If that is the case, then probably the quickest way to troubleshoot this will be to install CR 2008 on that computer (just to troubleshoot the issue and we'll uninstall once we are done). Once CR 2008 is installed, see if the report can run in the designer. If not, it will be much easier to see what needs to be done to the report in the designer to make it work, that working this from the runtime.

    Ludek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 06:27 AM

    Hi,

    This problem is occurring in our Dev environment, the production will not be upgraded until system integration has been proven. So production is still running CR XI R2, but everything else about Dev and production are the same.

    I can open the reports on a workstation, using either the Dev or Production environment as data sources, and this works ok, as expected, seeing as the reports have not been changed. The only change that has occurred is the installation of CR2008 runtime and .NET references change. I see nothing in the CR2008 docs about connection methods changing or did I miss something.

    Many thanks

    Tony

    Add comment
    10|10000 characters needed characters exceeded