Oracle connection

[Dave]

Hi,

Is it possible to use the "Reports.Designer.Web" with odac? If yes, how?

I'm using the trial version "Stimulsoft Reports.Web 2010.3 for Visual Studio 2005 - 2010"


Thanks

[Alex K.]

Hello,

You can download the Date Adapter for Oracle from our website, compile it and connect as a service in the designer.

Thank you.

[Dave]

You can download the Date Adapter for Oracle from our website

Is that;

Oracle Database pack
or
Oracle Data Provider for .NET Database pack (I've been trying to use this one)

(I'm using it with ASP.net)

compile it

Do you mean to include the project within my main project and compile them together, or compile the oracle adapter separately and then include the dll in my main project?

connect as a service in the designer.

How is this done?
Should the oracle connection just show up in the tool?
What if I want to programically define a connection string which the user cannot see or edit?

[Alex K.]

Hello,

Installation
To install unpack zip file to temp directory and then run project.
Then add Stimulsoft.Report.dll, Stimulsoft.Controls.dll, Stimulsoft.Base.dll
and Stimulsoft.Editor.dll to references of this project. Compile project. Copy compiled dll
to bin directory. At start of your program add following code:

StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleDatabase());

To attach the file to the Designer.exe just put the file assembly into the same
directory where the Designer.exe is located. Besides you should provide access
to the assembly of the provider of the database.

Thank you.

[Dave]

Yes, I had already seen the "installation.txt". but it doesn't make sense when I'm including this in a ASP.net website.

StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleDatabase());

These lines do not compile in my code-behind, I have included Stimulsoft.Report.OracleODP.dll in my bin folder and I still get:


Error: The type or namespace name 'StiOracleAdapterService' does not exist in the namespace 'Stimulsoft.Report.Dictionary' (are you missing an assembly reference?)

Error: The best overloaded method match for 'Stimulsoft.Base.Services.StiServiceContainer.Add(Stimulsoft.Base.Services.StiService)' has some invalid arguments

Error: Argument '1': cannot convert from 'Stimulsoft.Report.Dictionary.StiOracleAdapterService' to 'Stimulsoft.Base.Services.StiService'

Error: The type or namespace name 'StiOracleDatabase' does not exist in the namespace 'Stimulsoft.Report.Dictionary' (are you missing an assembly reference?)

Error: The best overloaded method match for 'Stimulsoft.Base.Services.StiServiceContainer.Add(Stimulsoft.Base.Services.StiService)' has some invalid arguments

Error: Argument '1': cannot convert from 'Stimulsoft.Report.Dictionary.StiOracleDatabase' to 'Stimulsoft.Base.Services.StiService'

[Dave]

For anyone else struggling with this try:

notice StiOracleODPAdapterService and not StiOracleAdapterService

Code: Select all

StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleODPAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleODPDatabase());

[Alex K.]

Hello,

There are two different versions of Oracle data adapters.
for Oracle Database:

Code: Select all

StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleDatabase());

for Oracle Data Provider for .NET Database pack:

Code: Select all

StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleODPAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiOracleODPDatabase());

Thank you.

[jay@bplogix.com]

The installation.txt says this project needs
Stimulsoft.Report.dll, Stimulsoft.Controls.dll, Stimulsoft.Base.dll, amd Stimulsoft.Editor.dll The project did not compile unless I also added Stimulsoft.Database.dll and Stimulsoft.Report.Design.dll
BUT ... the license agreement says we are only allowed to redistribute
Stimulsoft.Base.dll
Stimulsoft.Report.dll
Stimulsoft.Report.Web.dll
Stimulsoft.Report.WebFx.dll
Stimulsoft.Report.WebDesign.dll

Does this mean we canot distribute Oracle or any other data provider we download?? Is there something wrong with my project to need those other DLLs?

Thanks,
Jay

[Alex K.]

Hello,

What do you mean by distributing these dll files. These dlls are not required for building, displaying, and report generation in Web.

Thank you.

[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