Page 1 of 1

Unable to use Oracle.ODP package

Posted: Tue Jun 16, 2015 7:55 pm
by Phantom
Hi,

I'm trying to use an Oracle ODP connection and i'm getting the following error when i'm trying to preview the report:
The error of compilation
The error of compilation is found in the 'Report' report:
'Stimulsoft.Report.Dictionary.StiOracleODPDatabase' does not contain a constructor that takes 5 arguments
There is the generated code

Code: Select all

using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
        public Stimulsoft.Report.Components.StiPage Page1;
        public Stimulsoft.Report.Components.StiWatermark Page1_Watermark;
        public Stimulsoft.Report.Print.StiPrinterSettings Report_PrinterSettings;
        
        private void InitializeComponent()
        {
            this.NeedsCompiling = false;
            this.EngineVersion = Stimulsoft.Report.Engine.StiEngineVersion.EngineV2;
            this.ReferencedAssemblies = new string[] {
                    "System.Dll",
                    "System.Drawing.Dll",
                    "System.Windows.Forms.Dll",
                    "System.Data.Dll",
                    "System.Xml.Dll",
                    "Stimulsoft.Controls.Dll",
                    "Stimulsoft.Base.Dll",
                    "Stimulsoft.Report.Dll"};
            this.ReportAlias = "Report";
            // 
            // ReportChanged
            // 
            this.ReportChanged = new DateTime(2015, 6, 16, 15, 50, 7, 342);
            // 
            // ReportCreated
            // 
            this.ReportCreated = new DateTime(2015, 6, 16, 15, 49, 36, 253);
            this.ReportFile = "";
            this.ReportGuid = "52d41d51c6b54a79a30f7fc587cb0e9b";
            this.ReportName = "Report";
            this.ReportUnit = Stimulsoft.Report.StiReportUnitType.Inches;
            this.ReportVersion = "2015.1.0";
            this.ScriptLanguage = Stimulsoft.Report.StiReportLanguageType.CSharp;
            // 
            // Page1
            // 
            this.Page1 = new Stimulsoft.Report.Components.StiPage();
            this.Page1.Guid = "cedc53ebe72648b49c22e389ea44403f";
            this.Page1.Name = "Page1";
            this.Page1.PageHeight = 11;
            this.Page1.PageWidth = 8.5;
            this.Page1.PaperSize = System.Drawing.Printing.PaperKind.Letter;
            this.Page1.Border = new Stimulsoft.Base.Drawing.StiBorder(Stimulsoft.Base.Drawing.StiBorderSides.None, System.Drawing.Color.Black, 2, Stimulsoft.Base.Drawing.StiPenStyle.Solid, false, 4, new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Black), false);
            this.Page1.Brush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Transparent);
            this.Page1.ExcelSheetValue = null;
            this.Page1.Interaction = null;
            this.Page1.Margins = new Stimulsoft.Report.Components.StiMargins(0.39, 0.39, 0.39, 0.39);
            this.Page1_Watermark = new Stimulsoft.Report.Components.StiWatermark();
            this.Page1_Watermark.Font = new System.Drawing.Font("Arial", 100F);
            this.Page1_Watermark.Image = null;
            this.Page1_Watermark.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.FromArgb(50, 0, 0, 0));
            this.Report_PrinterSettings = new Stimulsoft.Report.Print.StiPrinterSettings();
            this.PrinterSettings = this.Report_PrinterSettings;
            this.Page1.Report = this;
            this.Page1.Watermark = this.Page1_Watermark;
            // 
            // Add to Pages
            // 
            this.Pages.Clear();
            this.Pages.AddRange(new Stimulsoft.Report.Components.StiPage[] {
                        this.Page1});
            this.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiOracleODPDatabase("Connection1", "Connection1", "USER ID=dev;DATA SOURCE=dev;PASSWORD=pwd", false, null));
        }
        #endregion StiReport Designer generated code - do not modify
    }
}

I'm using Stimulsoft Reports.Net version 2015.1 with the "Stimulsoft.Report.OracleODP.dll" that I have generated from your Oracle Database package.
In running under Oracle 12c database, when i'm testing the connection it's OK.

Re: Unable to use Oracle.ODP package

Posted: Wed Jun 17, 2015 6:38 am
by Alex K.
Hello,

Please check the archive in the attachment.

Also please check the last prerelease build. In the last versions (in prerelease builds after 2015.1 release) of our products we have made refactoring and improvements in the databases. Now it is not required to compile the additional data adapters. It is enough copy the necessary .dll files (Oracle.DataAccess) to the bin directory.

Thank you.