This is a migrated thread and some comments may be shown as answers.
.NET 5 Acessing Oracle
1 Answer 15 Views
This is a migrated thread and some comments may be shown as answers.
Henrique Duarte
Top achievements
Rank 1
Henrique Duarte asked on 01 Apr 2021, 09:17 PM

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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 Apr 2021, 10:00 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Asked by
Henrique Duarte
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or