Connecting to Oracle 11g [Designer.exe]

[victorinable]

Hi,

I'm having some issues trying to open a new Connection for a Database (Oracle 11g Enterprise Edition v11.2.0.1.0) since I cannot compile the Oracle Data Adapter (I've downloaded Oracle DataBase pack) because it raise some errors (This has been reported to helpDesk) and it's not possible for me to get the assemblies for it.

I followed the instrucions on the .txt but no luck. What I'm not doing properly? May I provide more info?

Thanks in advance for any hint.

[HighAley]

Hello.

You don't need to compile Oracle adapter.
It is included in our assemblies now.
You should just copy assembly of Oracle Data Access Component in bin folder.

Thank you.

[victorinable]

Hi Aleksey,

This was said to me from HelpDesk, but I'm not able to found this assembly. Can you please specify the path where is supposed to be located?

Thanks.

[HighAley]

Hello, Victor.

You should use one of third-party Data Provider. You could use one of next providers:
.NET Framework Data Provider for Oracle

Oracle Data Access Components

Devart Oracle Data Access Components

There you will find an assembly that you should put in bun folder.

Thank you.

[victorinable]

HI Aleksey,

I'm still having some doubts about how to use that on the proper way. I'll be so grateful if you or your team could describe how to use this kind of connectors (In my particular case, I'll use Oracle DataAccess for version 11g) as there is no documentatation about this and I'm really confused about how to succeed on that simple (Or at least it seems...) action. On the meanwhile, I have to use the Desktop designer and my MVC4 Application to render the reports, as I don't use an open connection to design, I use an empty DataSet to design using the Data Model and then, I only pass the Data once it's previewed or executed (I guess as most of people does...).

Thanks again for the response and help.

[HighAley]

Hello.

You should just put the Oracle.DataAccess.dll file to the bin folder to activate Oracle Data Access adapter.
Where do you have problems with the adapter? In Desktop designer or in MVC?
Could you describe what did you do and what is wrong?

Thank you.

[victorinable]

Hi,

I just do what is supposed to do and still having no Oracle Adapter to select. There are more steps to do? Should I connect in a different way?

Thanks.

[Alex K.]

Hello,

In last version we have made some changes with working with services.
Please try to use the following code:
StiConfig.Restore();

Thank you.

[victorinable]

Hi Aleksey

And Where I'm supposed to use this code, directly on the code section of the report? Of each report I'd like to connect to Oracle Database?

Thanks

[Alex K.]

Hello,

You don't need to compile Oracle adapter.
It is included in our assemblies now.

This changes have been added in the prerelease builds after 2015.1 release. Please try to check the last build 2015.1.15 from 2015.08.04.

Thank you.