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
Hi,
I tested the program Modules.exe with my application but I don’t captured Crystal Reports perhaps maybe the dll is called by an executable. So I tested with a small program and I reproduce two attach file, there is a differences in COMCTL32.dll and some DLLs are present only in a file.
The second test with xml file: I have not encountered any error.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry Anna. I don't see you answering my questions, rather you are leading me into places I don't want to go. E.g.; you are asking for help, I ask you to do certain tasks and tell me what the result of those was. I will not post anymore here - unless you can provide answers to my questions.
- Ludek
Hi,
I have still the same problem;
I attach my project: I was able to reproduce the error even at run-time.
My error is: “Impossibile caricare il file o l'assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' o una delle relative dipendenze. Impossibile trovare il file specificato.”
I have already insert to these lines of code in the App.config:
startup useLegacyV2RuntimeActivationPolicy="true" supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" /startup
I am using Visual Studio 2012 + Sql Server 2012.
Since i can not attach my project here is the line code:
Private Sub CrystalReportViewer1_Load(sender As Object, e As EventArgs) Handles CrystalReportViewer1.Load
Dim dtArticoli As DataTable
Dim Rpt As New CrystalReport1
cnDB("localhost\SQLEXPRESS", "WinPCOrdSQLSERVER", "agente", "SAEPinfo")
dtArticoli = LeggiArticoli(cnAttiva, "001", "", "", "") (the table has elements!)
Rpt.SetDataSource(dtArticoli) 'When This Line execute the error occur!
CrystalReportViewer1.ReportSource = Rpt
End Sub
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.