cancel
Showing results for 
Search instead for 
Did you mean: 

PROBLEMS WITH APPLICATION REDISTRIBUTION WITH WINDOWS 8.1

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Install the VS 2005 C++ Security runtime and then it should work. you can download it  from MSDN.

Don

Former Member
0 Kudos

Hi,

i installed the vs 2005  C++

(http://www.microsoft.com/it-it/download/details.aspx?id=5638)

but the problem is the same.

0 Kudos

OK then from the error is does appear to be database related so check the data sources and verify the client is installed and configured and the user has access to it.

Search for a kbase article with crlogger in it, you can enable it and it may tell you more details.

Don

Former Member
0 Kudos

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

0 Kudos

Hi Anna,

Logs are empty so it' snot even getting to that part of CR Runtime.

Try right clicking on your executable and selecting "Run as Administrator" or use Process Monitor from Microsoft and see if it catch any permission denied or access denied errors related to DB connectivity.

Don

Former Member
0 Kudos

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

former_member183750
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Ludek, 'dtArticoli = GestoreDati.LeggiArticoli (GestoreConn.cnAttiva, dtParametriApplicativi.Rows (0) ("CodAzienda"), "", "", "")'  is my funciton to populate a datatable (dtArticoli), while 'Rpt.SetDataSource (dtArticoli)' set datasource report with datatable (dtArticoli). Thanks Anna

former_member183750
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi, ok, I read the example; the example used a dataset while I use a datatable, but is the same. But I would remember the problem. The error occurs ONLY in Runtime WIN8.1x64, while it's OK in Runtime Win7x86 and in Development Win8.1x64... my question in "WHY?". Thanks Anna

Former Member
0 Kudos

Sorry! I wrote a wrong thing... The error occurs in Runtime Win8.1x86; I can't test Runtime Win8.1x64. Anna

former_member183750
Active Contributor
0 Kudos

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.

Troubleshooting Issues with VS .NET Datasets and Crystal Reports - Business Intelligence (BusinessOb...

- Ludek

Answers (2)

Answers (2)

Former Member
0 Kudos

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!

former_member183750
Active Contributor
0 Kudos

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

Former Member
0 Kudos

I'm sorry but I did not understand what are another questions.

I did more testing and the file of the differences is as follows:

Thanks!

Former Member
0 Kudos

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

former_member183750
Active Contributor
0 Kudos

Anna, were you able to follow the instructions in the troubleshooting blog ? If so, what were the results?

- Ludek