Page 1 of 1

How can I access to Oracle?

Posted: Fri Dec 11, 2015 1:19 pm
by rksaskia
Hello,

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

Connection works
connection.png
connection.png (67.54 KiB) Viewed 6645 times
Query works
query.png
query.png (81.82 KiB) Viewed 6645 times
We define a Report with this working connection/query
report.png
report.png (56.56 KiB) Viewed 6645 times
We view the Report
report_view.png
report_view.png (27.08 KiB) Viewed 6645 times
Monitor-Tool
monitor.png
monitor.png (153.72 KiB) Viewed 6645 times
The Oracle.DataAccess.dll is installed in the GAC.
gac.png
gac.png (122.31 KiB) Viewed 6645 times
What is wrong?

I have examined the assembly binding (fuslogvw.exe). Oracle.DataAccess was not loaded!!
fuslogvw.png
fuslogvw.png (133.12 KiB) Viewed 6645 times
Greetings

Re: How can I access to Oracle?

Posted: Mon Dec 14, 2015 7:46 am
by Alex K.
Hello,

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

Thank you.

Re: How can I access to Oracle?

Posted: Mon Dec 14, 2015 1:54 pm
by 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.

Re: How can I access to Oracle?

Posted: Wed Dec 16, 2015 2:45 pm
by 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?

Re: How can I access to Oracle?

Posted: Thu Dec 17, 2015 7:03 am
by 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.

Re: How can I access to Oracle?

Posted: Thu Dec 17, 2015 2:29 pm
by 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.

Re: How can I access to Oracle?

Posted: Fri Dec 18, 2015 5:53 am
by 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.