Oracle connection

Stimulsoft Reports.WEB discussion
jay@bplogix.com
Posts: 251
Joined: Fri Feb 04, 2011 11:46 am
Location: San Diego, CA

Oracle connection

Post by jay@bplogix.com »

The installation.txt says to include Stimulsoft.Controls.dll and Stimulsoft.Editor.dll, and it wont compile without Stimulsoft.Database.dll and Stimulsoft.Report.Design.dll.

Do these need to be distributed or are they just needed for building the Stimulsoft.Report.OracleODP.dll?

A couple other questions ...
- Why dont you simply supply the DLLs as a download? Why do you make us compile them?
- The projects only compile in Debug mode. In Relase mode there is a compile error:
C:\bp\Stimulsoft.Report.OracleODP\StiOracleODPAdapterService.cs(241,44): error CS0234: The type or namespace name 'StiOracleODPMetadataProvider' does not exist in the namespace 'Stimulsoft.Database' (are you missing an assembly reference?)
It looks like the Debug mode has a compilation symbol "Net2" that Release mode may need??
- What is the Demo configuration in the project?
- ConnectDataSourceToData in StiOracleODPAdapterService.cs has a NullReferenceException on line 119:
dataSource.DataTable = new DataTable();
when I click on "Retrieve Columns" with an oracle connection creating a New Data Source. Hitting continue in the debugger seems to allow it to continue with no problem. But the debugger is catching the unhandled exception.

thanks,
Jay
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Oracle connection

Post by Alex K. »

Hello Jay,

[quote="jay"@bplogix.com]The installation.txt says to include Stimulsoft.Controls.dll and Stimulsoft.Editor.dll, and it wont compile without Stimulsoft.Database.dll and Stimulsoft.Report.Design.dll.
Do these need to be distributed or are they just needed for building the Stimulsoft.Report.OracleODP.dll?[/quote]
These libraries are needed for building the Stimulsoft.Report.OracleODP.dll

[quote="jay"@bplogix.com]- Why dont you simply supply the DLLs as a download? Why do you make us compile them?[/quote]
We do not distribute finished version, since users will compile them for the version they need.

[quote="jay"@bplogix.com]- The projects only compile in Debug mode. In Relase mode there is a compile error:
C:\bp\Stimulsoft.Report.OracleODP\StiOracleODPAdapterService.cs(241,44): error CS0234: The type or namespace name 'StiOracleODPMetadataProvider' does not exist in the namespace 'Stimulsoft.Database' (are you missing an assembly reference?)
It looks like the Debug mode has a compilation symbol "Net2" that Release mode may need??[/quote]
We need some time to check the issue.

[quote="jay"@bplogix.com]- What is the Demo configuration in the project?[/quote]
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

[quote="jay"@bplogix.com]- ConnectDataSourceToData in StiOracleODPAdapterService.cs has a NullReferenceException on line 119:
dataSource.DataTable = new DataTable();
when I click on "Retrieve Columns" with an oracle connection creating a New Data Source. Hitting continue in the debugger seems to allow it to continue with no problem. But the debugger is catching the unhandled exception.[/quote]
We couldn't reproduce this bug. Could you explain your issue in more details and, if possible, send us a step-by-step guide how to reproduce the issue?

Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Oracle connection

Post by Alex K. »

Hello,

[quote="jay"@bplogix.com]- The projects only compile in Debug mode. In Relase mode there is a compile error:
C:\bp\Stimulsoft.Report.OracleODP\StiOracleODPAdapterService.cs(241,44): error CS0234: The type or namespace name 'StiOracleODPMetadataProvider' does not exist in the namespace 'Stimulsoft.Database' (are you missing an assembly reference?)
It looks like the Debug mode has a compilation symbol "Net2" that Release mode may need??[/quote]
We have made some corrections wiyhin one day an update will be available on our site.
On the current moment, set "Net2" in properties of the project.

Thank you.
jay@bplogix.com
Posts: 251
Joined: Fri Feb 04, 2011 11:46 am
Location: San Diego, CA

Oracle connection

Post by jay@bplogix.com »

Thanks.
jay@bplogix.com wrote:
"- What is the Demo configuration in the project?
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?"
When you open one of your projects in Visual Studio, you have created 3 "solution configurations" ... these control things like compiler defines, debug/build, etc. The three that you are distributing are Release, Build, and Demo (use the configuration manager to see these). My question is which one should we use?

jay@bplogix.com wrote:
"- ConnectDataSourceToData in StiOracleODPAdapterService.cs has a NullReferenceException on line 119:
dataSource.DataTable = new DataTable();
when I click on "Retrieve Columns" with an oracle connection creating a New Data Source. Hitting continue in the debugger seems to allow it to continue with no problem. But the debugger is catching the unhandled exception.
We couldn't reproduce this bug. Could you explain your issue in more details and, if possible, send us a step-by-step guide how to reproduce the issue?"
I am running using the "Debug" configuration ... it may not be caught if not in that mode. Basically create any Oracle ODP.NET connection (this works fine). Then create a DataSource in that connection and use a simple Query Text like "SELECT * FROM MYTABLE" ... hit Retrieve Columns on the dialog and the debugger catches a NullReferenceException in ConnectDataSourceToData in StiOracleODPAdapterService.cs on line 119 ... I can reproduce this when I compile my project and the Oracle DLL in debug mode. Hitting continue seems to make everything work fine ... you probably have an exception handler just ignoring any exceptions in ConnectDataSourceToData ... but perhaps there is a hidden problem?

Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Oracle connection

Post by Alex K. »

Hello,

[quote="jay"@bplogix.com]When you open one of your projects in Visual Studio, you have created 3 "solution configurations" ... these control things like compiler defines, debug/build, etc. The three that you are distributing are Release, Build, and Demo (use the configuration manager to see these). My question is which one should we use?[/quote]
We did not exactly understand your question. For compilation of what do you want to select "solution configurations"? If for compilation of the data adapter, then there is no difference what to select, you can select "Release".

[quote="jay"@bplogix.com]I am running using the "Debug" configuration ... it may not be caught if not in that mode. Basically create any Oracle ODP.NET connection (this works fine). Then create a DataSource in that connection and use a simple Query Text like "SELECT * FROM MYTABLE" ... hit Retrieve Columns on the dialog and the debugger catches a NullReferenceException in ConnectDataSourceToData in StiOracleODPAdapterService.cs on line 119 ... I can reproduce this when I compile my project and the Oracle DLL in debug mode. Hitting continue seems to make everything work fine ... you probably have an exception handler just ignoring any exceptions in ConnectDataSourceToData ... but perhaps there is a hidden problem?[/quote]
We need some additional time to check and fix the issue.

Thank you.
jay@bplogix.com
Posts: 251
Joined: Fri Feb 04, 2011 11:46 am
Location: San Diego, CA

Oracle connection

Post by jay@bplogix.com »

When I compile the DLL in release mode, it does not thow an exception (Debug mode generates more runtime error checking - it is different than Release mode). It seems to work in Release mode, but the exception in Debug mode may indicate a hidden bug.

"We did not exactly understand your question. For compilation of what do you want to select "solution configurations"? If for compilation of the data adapter, then there is no difference what to select, you can select "Release"."

If you open your project in Visual Studio, right click on the project and select Configuration Manager. In that dialog you will see that you created a "Demo" configuration in addition to "Release" and "Debug" (you can create any number of configurations that do things like add pre-compiler variables). It looks like "Demo" should not be used ... perhaps it was left there by accident by your developers? In any case, Net2 needs to be added to the Release configuration to make it compile.

Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Oracle connection

Post by Alex K. »

Hello,

We have made some changes. Please download the data adapter from site again.

Thank you.
Post Reply