.NET 5 Acessing Oracle

[Henrique Duarte]

Hello!

I am evaluating the tool for my company.
I am creating a .NET 5 application that accesses an Oracle database.
Through the designer, I managed to assemble the report and managed to view the information through the Preview.
When I try to run the report and export a PDF I get the following message:
"Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. "

Is there a document on how to export a report as PDF using .NET 5 and accessing the Oracle database?

[Todor]

Hello Henrique,

If I understood correctly, you have managed to connect successfully your report to the Oracle database in the Standalone Report Designer, and the Preview was as expected. Note that the designer is a .NET application and requires a .NET data provider to connect to the data source.

In the .NET 5 application hosting the Reporting engine, you need a data provider for the .NET Core framework. The KB article How to register a DbProviderFactory in a .NET Core project lists the providers we support out-of-the-box in .NET Core and explains how you may register another data provider.

Note that you also need to register the connection string in the JSON configuration file of your .NET 5 application if you use a named/shared connection string. See the article How to Host Reports Service in ASP.NET Core in .NET 5 for the available options.

Regards,
Todor
Progress Telerik