Page 1 of 2

求助:自定义Oracle适配器问题

Posted: Tue Sep 24, 2019 1:09 am
by xiangzi919
Hello !
         We used the Stimulsoft.Report.Net 2015 version.It connects to Oracle using Stimulsoft.Report.OracleODP;The report we wrote earlier is based on Stimulsoft.Report.OracleODP.
Stimulsoft.Report.OracleODP is not supported in the latest version.The oracle parameter cannot be assigned by name, and can only be assigned according to the order of the parameters.
We are considering an upgrade. If we upgrade to a new version, how do I be compatible with previous reports?The stimulsoft.report.oracleodp.dll supports assignment by parameter name. The latest version of Stimulsoft.Report.Net has integrated the Oracle Data Adapter.((oracle dataadapter)dataadapter).selectcommand.bindbyname=true; but now this property is not supported in newer versions of adapters
          We have rewritten the adapter CustomOracleODPAdapterService, CustomOracleODPDatabase, CustomOracleODPSource report designer to identify, can write data sources and queries, and put the data source into the report designer for preview error:
"The error of compilation
The error of compilation is found in The 'test1' report:
Namespace "Stimulsoft. Report. The Dictionary" does not exist in the type or namespace name "CustomOracleODPSource" (lack of assembly references?)"
Specific code : public class 数据源2DataSource : Stimulsoft.Report.Dictionary.CustomOracleODPSource Hint missing assembly reference

Re: 求助:自定义Oracle适配器问题

Posted: Tue Sep 24, 2019 10:33 am
by Lech Kulikowski
Hello,

In last versions, all adapters were included in report engine. But you can add your old ODP data adapter from the old version:
StiOptions.Services.DataAdapters.Add(new CustomOracleODPAdapterService());
StiOptions.Services.Databases.Add(new CusomOracleODPDatabase());

Thank you.

Re: 求助:自定义Oracle适配器问题

Posted: Wed Sep 25, 2019 1:32 am
by xiangzi919
Hello:

I have added a custom adapter to the code
StiOptions. Services. DataAdapters. Add (new Custom Oracle ODPAdapter Service ());
StiOptions. Services. Databases. Add (new Custom Oracle ODPDatabase ());
Still prompted in the report designer: "The error of compilation is found in the'test1'report: Namespace“Stimulsoft.Report.Dictionary”"does not exist in the type or namespace name"CustomOracleODPSource"(lack of assembly references?)

Here is a screenshot of the code:
The attachment 1.png is no longer available
2.png
2.png (148.1 KiB) Viewed 3530 times
3.png
3.png (224.11 KiB) Viewed 3530 times

Re: 求助:自定义Oracle适配器问题

Posted: Thu Sep 26, 2019 7:47 am
by Lech Kulikowski
Hello,

Please check the custom adapter (based on PostgreSQL) with changes for last versions.

Thank you.

Re: 求助:自定义Oracle适配器问题

Posted: Fri Sep 27, 2019 8:57 am
by xiangzi919
Hello!

I rewrote the Oracle adapter according to demo provided by you.
The problem is still unresolved, just like the previous error.
I uploaded the rewritten adapter to the attachment,please help me.
Stimulsoft.Report.OracleODP.rar
(28.11 KiB) Downloaded 330 times

Re: 求助:自定义Oracle适配器问题

Posted: Wed Oct 02, 2019 9:37 am
by Lech Kulikowski
Hello,

We need some additional time to investigate the issue.

Thank you.

Re: 求助:自定义Oracle适配器问题

Posted: Tue Nov 05, 2019 1:38 am
by xiangzi919
Hello,
how is the question verified?
Thank you!

Re: 求助:自定义Oracle适配器问题

Posted: Thu Nov 07, 2019 9:04 pm
by Lech Kulikowski
Hello,

Please check the last release build.

Also, please check that you added your assembly in the (Referenced Assemblies) property of the report.

Thank you.

Re: 求助:自定义Oracle适配器问题

Posted: Wed Nov 27, 2019 9:54 am
by xiangzi919
Hello:

I download the latest version again, or I will prompt the original error; can I provide a demo

Re: 求助:自定义Oracle适配器问题

Posted: Tue Mar 03, 2020 7:26 am
by xiangzi919
Hello,
how is the question verified?
Thank you!