How can I access to Oracle?

[rksaskia]

Hello,

we evaluate the server with Oracle. At view of the report, an error occurs.

Connection works

connection.png (67.54 KiB) Viewed 5130 times

Query works

query.png (81.82 KiB) Viewed 5130 times

We define a Report with this working connection/query

report.png (56.56 KiB) Viewed 5130 times

We view the Report

report_view.png (27.08 KiB) Viewed 5130 times

Monitor-Tool

monitor.png (153.72 KiB) Viewed 5130 times

The Oracle.DataAccess.dll is installed in the GAC.

gac.png (122.31 KiB) Viewed 5130 times

What is wrong?

I have examined the assembly binding (fuslogvw.exe). Oracle.DataAccess was not loaded!!

fuslogvw.png (133.12 KiB) Viewed 5130 times

Greetings

[Alex K.]

Hello,

Please send us a request on the support@stimulsoft.com, we will try to prepare the build for you.

Thank you.

[Alex K.]

Hello,

Please try to remove the Devart.Data.Oracle.dll and copy your Oracle.DataAccess.dll instead it by the following pass:
[C]:\ProgramData\Stimulsoft-Server\Release\

Thank you.

[rksaskia]

Hello,

we have no Devart.Data.Oracle.dll in our Release directory: C:\ProgramData\Stimulsoft-Server\Software-Releases\2015.3.2

The Oracle.Data.Access is in GAC, .Net load assemblies allways from gac first.

Any other idea?

[Alex K.]

Hello,

Due to the license agreement we could't include this assemblies in our product.
But we made some improvements in that direction. Please check the new build at the following link:
http://admin.stimulsoft.com/downloads/S ... 2015.3.exe

Thank you.

[rksaskia]

Hello,

i can confirm that your improvement work.

Tip: It would be better to read only the tables of the current schema owner (user from the connection string).

Thank you.

[Alex K.]

Hello,

i can confirm that your improvement work.

We are always glad to help you!

Tip: It would be better to read only the tables of the current schema owner (user from the connection string).

It gets all available information for this user, which allow for him on the server.

Thank you.