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

Stimulsoft Reports.NET discussion
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post 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
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post 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.
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post 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 3264 times
3.png
3.png (224.11 KiB) Viewed 3264 times
Attachments
1.png
1.png (208.3 KiB) Viewed 3264 times
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
Attachments
Stimulsoft.Report.PostgreSQL.zip
(8.44 KiB) Downloaded 170 times
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post 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 251 times
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue.

Thank you.
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post by xiangzi919 »

Hello,
how is the question verified?
Thank you!
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post 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.
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post by xiangzi919 »

Hello:

I download the latest version again, or I will prompt the original error; can I provide a demo
Attachments
3.png
3.png (29.41 KiB) Viewed 2866 times
2.png
2.png (217.04 KiB) Viewed 2866 times
1.png
1.png (73.85 KiB) Viewed 2866 times
xiangzi919
Posts: 6
Joined: Tue Sep 24, 2019 12:54 am

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

Post by xiangzi919 »

Hello,
how is the question verified?
Thank you!
Post Reply