on 07-10-2014 2:06 PM
Hi, we developed a vb.net2012 application with CrystalReport 13.0.10; database is SqlServer2012 installed on localhost. We build setup (with CR runtime 13.0.10) and install to a PC with Windows8.1 32bit, but when we launch the application an error occurs; while in a PC with windows7 the error doesn’t occur. CrystalDecisions.CrystalReports.Engine.DataSourceException: Impossibile caricare le informazioni del database. Errore nel file temp_b7d9c2ef-3b7e-49a3-ab47-d534878340a6 {1DF06FCE-401F-464C-95DC-5C7B9184D911}.rpt: Impossibile caricare le informazioni del database. ---> System.Runtime.InteropServices.COMException: Impossibile caricare le informazioni del database. Errore nel file temp_b7d9c2ef-3b7e-49a3-ab47-d534878340a6 {1DF06FCE-401F-464C-95DC-5C7B9184D911}.rpt: Impossibile caricare le informazioni del database. in CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.ReplaceConnection(Object oldConnection, Object newConnection, Object parameterFields, Object crDBOptionUseDefault) in CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type) in CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type) --- Fine della traccia dello stack dell'eccezione interna --- in CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) in CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type) in CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet) in Stampe.frmVisualizzazioneReport.ParametrizzaReport() in Stampe.frmVisualizzazioneReport.frmVisulizzazioneReport_Load(Object sender, EventArgs e) in System.Windows.Forms.Form.OnLoad(EventArgs e) in System.Windows.Forms.Form.OnCreateControl() in System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) in System.Windows.Forms.Control.CreateControl() in System.Windows.Forms.Control.WmShowWindow(Message& m) in System.Windows.Forms.Control.WndProc(Message& m) in System.Windows.Forms.ScrollableControl.WndProc(Message& m) in System.Windows.Forms.ContainerControl.WndProc(Message& m) in System.Windows.Forms.Form.WmShowWindow(Message& m) in System.Windows.Forms.Form.WndProc(Message& m) in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Assembly caricati ************** mscorlib Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll ---------------------------------------- WinPCOrd Versione assembly: 0.1.0.0 Versione Win32: 0.1.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/WinPCOrd.exe ---------------------------------------- Microsoft.VisualBasic Versione assembly: 10.0.0.0 Versione Win32: 12.0.20806.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Core Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Windows.Forms Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Runtime.Remoting Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- System.Configuration Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- Comuni Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/Comuni.DLL ---------------------------------------- GestoreDB Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/GestoreDB.DLL ---------------------------------------- System.Data Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Windows.Forms.resources Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_it_b77a5c561934e089/System.Windows.Forms.resources.dll ---------------------------------------- System.Transactions Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- System.Numerics Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll ---------------------------------------- AggiornaArchivi Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/AggiornaArchivi.DLL ---------------------------------------- OdVTesLista Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/OdVTesLista.DLL ---------------------------------------- C1.Win.C1TrueDBGrid.4 Versione assembly: 4.0.20141.61347 Versione Win32: 4.0.20141.61347 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/C1.Win.C1TrueDBGrid.4.DLL ---------------------------------------- C1.Win.C1Ribbon.4 Versione assembly: 4.0.20141.558 Versione Win32: 4.0.20141.558 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/C1.Win.C1Ribbon.4.DLL ---------------------------------------- mscorlib.resources Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_it_b77a5c561934e089/mscorlib.resources.dll ---------------------------------------- Accessibility Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- Viste Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/Viste.DLL ---------------------------------------- C1.Win.C1Sizer.4 Versione assembly: 4.1.20141.81 Versione Win32: 4.1.20141.81 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/C1.Win.C1Sizer.4.DLL ---------------------------------------- System.Data.DataSetExtensions Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll ---------------------------------------- Stampe Versione assembly: 1.0.0.0 Versione Win32: 1.0.0.0 Base di codice: file:///C:/Program%20Files/Saep/WinPCOrd/Stampe.DLL ---------------------------------------- CrystalDecisions.CrystalReports.Engine Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/13.0.2000.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll ---------------------------------------- CrystalDecisions.Shared Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Shared.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CommLayer Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CommLayer/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CommLayer.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ClientDoc Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ClientDoc/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ClientDoc.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataDefModel Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CubeDefModel Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.CubeDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CubeDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ReportDefModel Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.ReportDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ReportDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.Controllers Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.Controllers/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.Controllers.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataSetConversion Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataSetConversion/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataSetConversion.dll ---------------------------------------- System.Web Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.34209 built by: FX452RTMGDR Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- log4net Versione assembly: 1.2.10.0 Versione Win32: 1.2.10.0 Base di codice: file:///C:/Windows/assembly/GAC_32/log4net/1.2.10.0__692fbea5521e1304/log4net.dll ---------------------------------------- CrystalDecisions.Shared.resources Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared.resources/13.0.2000.0_it_692fbea5521e1304/CrystalDecisions.Shared.resources.dll ---------------------------------------- CrystalDecisions.Windows.Forms Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Windows.Forms.dll ---------------------------------------- CrystalDecisions.ReportSource Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportSource/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportSource.dll ---------------------------------------- CrystalDecisions.Windows.Forms.resources Versione assembly: 13.0.2000.0 Versione Win32: 13.0.10.1385 Base di codice: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms.resources/13.0.2000.0_it_692fbea5521e1304/CrystalDecisions.Windows.Forms.resources.dll ---------------------------------------- CustomMarshalers Versione assembly: 4.0.0.0 Versione Win32: 4.0.30319.33440 built by: FX45W81RTMREL Base di codice: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/CustomMarshalers/v4.0_4.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll Thanks for your reply, Regards
Install the VS 2005 C++ Security runtime and then it should work. you can download it from MSDN.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
i installed the vs 2005 C++
(http://www.microsoft.com/it-it/download/details.aspx?id=5638)
but the problem is the same.
Hi,
i got these 2 files: WinPCOrd_3000_2014-7-14-14-31-54_assert.log this is empty WinPCOrd_3000_2014-7-14-14-31-54_runtime.log while it contains the following lines: TIMESTAMP THREAD_ID FILENAME LINE_NUMBER LOGGED_DATA LEVEL 2014-7-14-14-31-54 3000. \ Ado.cpp 2950 Begin DbMatchLogonInfo 20 2014-7-14-14-31-55 3000. \ Ado.cpp 2981 Begin DbMatchLogonInfo 20.
My problem doesn't resolve.
Anna
Hi, I have done other tests, I checked that I run the project as an administrator, the permission of database is “full controll” for the user Everyone but my problem is still there.
I insert the test and the line that goes wrong is the following: Rpt.SetDataSource (dtArticoli) I see the message "Test 1" while before the second message the application reproduces the error!
The datatable contains 6000 elements.
This following is my code:
Private Sub frmVisulizzazioneReport_Load (sender As Object, e As EventArgs) Handles Me.Load
Dim dtArticoli as Datatable
Dim As New cryRpt CryArticoli
dtArticoli = GestoreDati.LeggiArticoli (GestoreConn.cnAttiva, dtParametriApplicativi.Rows (0) ("CodAzienda"), "", "", "")
msgbox ("Test 1")
Rpt.SetDataSource (dtArticoli) 'This line when I execute the error.
msgbox ("test 2")
CrystalReportViewer1.ReportSource = Rpt
P.S. I do not understand why the CRYSTALREPORTLOG don’t Displayed, anything other application while the file is written
Anna
The code does not make any sense at all. Do you actually want to log in to the database, or do you want to pass the report a dataset?
E.g.; this code looks like you want to log in to the database:
dtArticoli = GestoreDati.LeggiArticoli (GestoreConn.cnAttiva, dtParametriApplicativi.Rows (0) ("CodAzienda"), "", "", "") |
This code would normally be used to pass in an ADO .NET Dataset to the report:
Rpt.SetDataSource (dtArticoli)
What you want to do is have a look at a few samples and do a bit more reading on how to set data sources for CR.
Samples
vbnet_win_dbengine.zip from here: Crystal Reports for .NET SDK Samples - Business Intelligence (BusinessObjects) - SCN Wiki
Documentation
Crystal Reports for Visual Studio 2005 Walkthroughs (applies to all versions of CR and .NET)
Developer Help Files
SAP Crystal Reports .NET SDK Developer Guide
SAP Crystal Reports .NET API Guide
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
So, from MS:
The DataTable class is a member of the System.Data namespace within the .NET Framework class library. You can create and use a DataTable independently or as a member of a DataSet, and DataTable objects can also be used in conjunction with other .NET Framework objects, including the DataView. You access the collection of tables in a DataSet through the Tables property of the DataSet object.
That being the case, please have a look at the following:
csharp_win_adodotnet.zip from here: Crystal Reports for .NET SDK Samples - Business Intelligence (BusinessObjects) - SCN Wiki
Crystal Reports for Visual Studio 2005 Walkthroughs Page 332
- Ludek
The error tells me that the CR engine does not understand the data structure being passed to it. This may be something like incorrect data type on one of the fields, an expected field missing, etc., etc. The following wiki describes trouble shooting steps for datasets and should be the same for data table. See if it helps.
- Ludek
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.