Error to conect dataset to crystal report file instance.

[Former Member]

I have a .Net aplication,  developed with microsoft vb.net 2010, MySQL databbase 5.5  and Crystal Reports for vs2010 (spanish).  To prtint reports, the program get a dataset with data to print, but when try to conect the dataset to report,  return a error. My code is:

Dim crpDataset As new dataset

Dim crpReport As New ReportDocument

'call procedure to get data to print

call datosReporte(crpDataset)

crpReport .Load("c:\core manager software\Ordentrabajo.rpt")

crpReport.SetDataSource(crpDataset)

The error message is:

"No es posible cargar la información de la base de datos. Error en el archivo Ordentrabajo{16733AAC-BA47--47FE-BB82-0829311C536D}.rpt: No se pudo cargar la información de la base de datos.

Traslate:

Is not posible load the information of databse. Error in file Ordentrabajo{16733AAC-BA47--47FE-BB82-0829311C536D}.rpt: Can´t to load the informatiojn of databse.

The OS is Windows Server 2012.  In other server, with Windows server 2008 work OK. Please, if any people know about this problem, thanks for you help.

Filino López

[abhilash_kumar · Accepted solution]

Hi Filino,

Please repost to the SAP Crystal Reports, version for Visual Studio space.

-Abhilash

[Former Member · Accepted solution]

Thanks for answer me.

I work with Crystal Reports for visual Studio 2010 ( 13.0.3).

Filino

[former_member183750 · Accepted solution]

I moved your post to the SAP Crystal Reports, version for Visual Studio Topic Space.

Update your dev and runtime computers to Service Pack 7. You are on SP 3 at this time. See this document for links.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

Thanks. I updated to CR 13.0.7 version, but the problem  continues.

[former_member183750 · Accepted solution]

Not sure if KBA 1870767 - Error: Failed to load database information when trying to set report datasource to a datas...will help. I'd assume as this works in WIN 2008, you already do that, but please do confirm.

- Ludek

[Former Member · Accepted solution]

This segment is included in the app.config now. But the problem continues. The messages complete is it:

Environment

• Visual Studio 2010
• Crystal Reports for Visual Studio: 13.0.7
• .NET 4 framework
• Windows application running windows server 2012

CrystalDecisions.CrystalReports.Engine.DataSourceException:

Error en el archivo docEntrada {CB3ACB46-E16A-4A1C-8471-1974A2E9EF60}.rpt:

No se pudo cargar la información de la base de datos. ---> System.Runtime.InteropServices.COMException:

Error en el archivo docEntrada {CB3ACB46-E16A-4A1C-8471-1974A2E9EF60}.rpt:

No se pudo cargar la información de la base de datos.

   en CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.GetLastPageNumber(RequestContext pRequestContext)

   en CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext)

   --- Fin del seguimiento de la pila de la excepción interna ---

   en CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

   en CrystalDecisions.ReportSource.EromReportSourceBase.HandleException(Exception exception)

   en CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext)

   en CrystalDecisions.CrystalReports.Engine.FormatEngine.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN)

   en CrystalDecisions.CrystalReports.Engine.ReportDocument.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN)

   en CoreManagerInterface.mConsultas.ImprimirDocumento(Int32 pIdDocumento, String pArchivoRpt, Boolean pPantalla)

   en CoreManagerInterface.clsInterface2.Button4_Click(Object sender, EventArgs e)

   en System.Windows.Forms.Control.OnClick(EventArgs e)

   en System.Windows.Forms.Button.OnClick(EventArgs e)

   en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

   en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

   en System.Windows.Forms.Control.WndProc(Message& m)

   en System.Windows.Forms.ButtonBase.WndProc(Message& m)

   en System.Windows.Forms.Button.WndProc(Message& m)

   en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Ensamblados cargados **************

mscorlib

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

----------------------------------------

Core Manager Software

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 1.0.0.0

    Código base: file:///D:/Core%20Manager%20Software/Core%20Manager%20Software.exe

----------------------------------------

System.Data

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Core

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

----------------------------------------

System.Xml

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

Microsoft.VisualBasic

    Versión del ensamblado: 10.0.0.0

    Versión Win32: 11.0.50709.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll

----------------------------------------

System.Windows.Forms

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System.Drawing

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Windows.Forms.resources

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_es_b77a5c561934e089/System.Windows.Forms.resources.dll

----------------------------------------

MySql.Data

    Versión del ensamblado: 6.5.4.0

    Versión Win32: 6.5.4.0

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/MySql.Data/v4.0_6.5.4.0__c5687fc88969c44d/MySql.Data.dll

----------------------------------------

System.Transactions

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.Configuration

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.EnterpriseServices

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

System.Numerics

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

----------------------------------------

mscorlib.resources

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_es_b77a5c561934e089/mscorlib.resources.dll

----------------------------------------

CrystalDecisions.CrystalReports.Engine

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/13.0.2000.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll

----------------------------------------

CrystalDecisions.Shared

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Shared.dll

----------------------------------------

CrystalDecisions.ReportAppServer.CommLayer

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CommLayer/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CommLayer.dll

----------------------------------------

CrystalDecisions.ReportAppServer.ClientDoc

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ClientDoc/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ClientDoc.dll

----------------------------------------

CrystalDecisions.ReportAppServer.DataDefModel

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataDefModel.dll

----------------------------------------

CrystalDecisions.ReportAppServer.CubeDefModel

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CubeDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CubeDefModel.dll

----------------------------------------

CrystalDecisions.ReportAppServer.ReportDefModel

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ReportDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ReportDefModel.dll

----------------------------------------

CrystalDecisions.ReportAppServer.Controllers

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.Controllers/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.Controllers.dll

----------------------------------------

CrystalDecisions.ReportAppServer.DataSetConversion

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataSetConversion/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataSetConversion.dll

----------------------------------------

System.Web

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll

----------------------------------------

log4net

    Versión del ensamblado: 1.2.10.0

    Versión Win32: 1.2.10.0

    Código base: file:///C:/Windows/assembly/GAC_32/log4net/1.2.10.0__692fbea5521e1304/log4net.dll

----------------------------------------

CrystalDecisions.Shared.resources

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared.resources/13.0.2000.0_es_692fbea5521e1304/CrystalDecisions.Shared.resources.dll

----------------------------------------

System.Web.Services

    Versión del ensamblado: 4.0.0.0

    Versión Win32: 4.0.30319.17929 built by: FX45RTMREL

    Código base: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll

----------------------------------------

CrystalDecisions.ReportSource

    Versión del ensamblado: 13.0.2000.0

    Versión Win32: 13.0.3.612

    Código base: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportSource/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportSource.dll

----------------------------------------

************** Depuración JIT **************

Para habilitar la depuración Just In Time (JIT), el archivo de configuración de esta

aplicación o equipo (machine.config) debe tener el

valor jitDebugging establecido en la sección system.windows.forms.

La aplicación también se debe compilar con la depuración

habilitada

Por ejemplo:

<configuration>

    <system.windows.forms jitDebugging="true" />

</configuration>

Cuando esté habilitada la depuración JIT, cualquier excepción no controlada

se enviará al depurador JIT registrado en el equipo

en lugar de controlarlo mediante el cuadro de diálogo.

[former_member183750 · Accepted solution]

OK. Now have a look at this wiki and see if it helps.

- Ludek

[Former Member]

Hi Ludek,

2 weeks ago I have this problem and I could not fix it. My application is developed in VB.net 2010 with MySQL 5.59 and Crystal Reports version 13.0.7. My pc work, run Windows 7 on it and have no problem, but when I install on a server with WinServer 2012, to produce the report fails to connect the dataset to the report. Clarified that the dataset is not tipado, its created at runtime. That is so, because my application is an ERP, and its 60 reports, and create a dataset in design mode for each report, that is not practical. The funny thing is that I have the application running in Windows Server 2008 and works ok. But this is the first time I install on WinServer 2012 and I could not do what CrystalReports work. Any idea? Post a picture of the error.

[former_member183750]

Interesting...

SP 7 does supposedly work on WIN 2012 (at least it says so in the Supported Platforms...).

Can you do me a favor and try with SP 8?

If that fails, I'll test a project that uses ADO .NET on WIN 2012

- Ludek

[Former Member]

Thanks for help me...

I already tried with SP8. and gives the same error. Additionally, there are 3 pc with Windows 8, 64  Bits OS. I did the same installation, and only one of them prints well. The other 2 PC, give the same error. Likewise, I tried on 3 pc with Windos XP, and in this OS work ok. But the server has not been possible to work.

Thanks in advance for what you can do to help me.

Filino López

Bogotá, Colombia.

[former_member183750]

Ahhh, well if one works, and two do not, then it is not CR or OS. More than likely it is an issue with the dataset. I'd like you to look at this wiki and follow the steps there to troubleshoot the issue.

- Ludek