Connecting to Oracle 11g [Designer.exe]

[victorinable]

Hi,

I'm sorry to say that you're confusing me more than solving my problem.

Please, again, what are the steps to Connect with Desktop Editor to Oracle Database? As I said more than once before, I'm using LAST release of your software. What's the meaning of your last reply? what's this related to my question? I said I included the assembly you told me before on the Bin folder of the Desiger.exe and still don't see oracle Adapter.

Please, tell me wich are the steps to follow or at least some documentation where I can see how to do that!

I don't want to seem rude, but I have spent lot of time with that issue.

Thanks.

[HighAley]

Hello.

Sorry for confusing you.

You didn't wrote what version of our assemblies you use.
After our last major release that you use there were published many prerelease builds.
You use release version 2015.1 from 27/04/2015 as we see it on your screen-shot.
Our latest prerelease build version is 2015.1.15 from 04/08/2015.

In one of our prerelease builds that was published after 2015.1 release we included database adapters.
But for your build you should compile database adapter from project that you could download from our site.
If you upgrade to the latest prerelease build you will not need to compile additional project and just put necessary dll in the bin folder as you did before.

Sorry again for misunderstanding. Let us know if we can help you in something else.

Thank you.

[victorinable]

Hi Aleksey,

As you can see in the Files attached, I downloaded last version of pre-release as you told me, I included the assembly and got the error you can see in the file attached.

Thanks.

[victorinable]

Hi,

I found the solution by using different Assemblies. Correct One (For me) is: Oracle.ManagedDataAccess.dll.

Once this is done connection String should be:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;

So, finally, this case is resolved succesfully. Now I'll try to pass that connection programaticcally from my MVC4 application. Any recomendation?

Thanks in advance.

[HighAley]

Hello.

It's very good news that finally you get Oracle connection working.

If you already have Oracle connection in the report and need to change connection string you could use next code:

Code: Select all

((StiSqlDatabase)report.Dictionary.Databases["Connection"]).ConnectionString = ""

If you have other type of connection and need to change it. You should use next code:

Code: Select all

report.Dictionary.Databases.Clear();
report.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiOracleDatabase("Connection", newConnectionString));

The name of the connection should the same as in removed one.

Thank you.

[victorinable]

Hi Aleksey,

Thanks for the support. By The way, this is just testing to have an overview of the different posibilities we can offer to our customers by giving them the possibility to feed the report with external sources (Maybe their ones ore from other partners) so this is great for them, as they can have more possibilities, but that mean more research work fro us (For example to reach that connection working perfectly and to understand how to do the same for other technologies/architectures).

For me, this issue is resolved, more doubts from different topics will be posted soon...

Thanks again!

[HighAley]

Hello.

We are always glad to help you.
Sorry, for some undocumented features, we are continuously working on our documentation and all missed documentation about Database Connections will be added soon.
We hope that there will no such long solving problems while you evaluate our product.
Let us know if you need any additional help.

Thank you.