Unable to Connect to telerik reporting with Oracle database

1 Answer 199 Views
.NET Core DataSource SQL General Discussions Report Designer (standalone) Report Viewer - Blazor
Akhil
Top achievements
Rank 1
Akhil asked on 04 Sep 2023, 11:02 AM

I wish to integrate a telerik report viewer into a blazor application (I am using Dot net 6.0).. I have set up a Reporting Server also using Dot net 6.0
I wish to use Oracle db as the data Source of my application
I have tried the following steps

1.Opened the default Telerik.ReportDesigner

2.Clicked on new and added the datasource

3.Selected Sql Data Source

4.Clicked on build new connection and selected OracleClient Data Provider

5.Chose build option

6. In the Data Source clicked on change and selected  .Net Framework Data provider for Ole Db (as the other one is shown as deprecated)

7. Filled the feilds and when cliked on test connection, it is showing " The  'MSDORA' provider is not registered on the local machine"


I looked into the issue and tried shifting to Telerik.ReportDesigner x86 application

I followed the same steps as above and when i clicked on "test connection", it is showing an error  "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version on 7.3.3 or later client software installation.Provider is unable to function until these components are installed"

which application should i use and is there any solution to get rid of this error
Kindly provide as solution for this
I am using Oracle Db version "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production"

my connection string is like "Data Source={111.111.1.11:2222};User Id={useid};Password={pass}"

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 05 Sep 2023, 11:39 AM

Hi Akhil,

We discussed this in a support ticket but to share what is the recommended approach with the community, we recommend using the newer Oracle.ManagedDataAcccess.Client data provider when working with Oracle database and using .NET Core - System.Data.OracleClient is deprecated in .NET Framework - Telerik Reporting.

For that, you need to either install the provider or register it without installation. You may download the necessary files from Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database.

In case you prefer to use the deprecated System.Data.OracleClient provider, you would need to specifically register it within the .NET 6 project that you have, please visit How to register a new DbProviderFactory instance in a .NET Core project - Telerik Reporting for details.

Once you have done either of the above, if you use a shared connection with your SqlDataSource components, please make sure to specify the data provider that your connection should use in the connection string object, for example(appsettings.json):

  "ConnectionStrings": {
    "Connection1": {
      "connectionString": "Data Source=TORCL;User Id=myUsername;Password=myPassword;",
      "providerName": "Oracle.ManagedDataAccess.Client"
    }
  }

If you need help with the format of the connection string, I recommend having a look at the Oracle connection strings - ConnectionStrings.com site which has many examples.

Please let me know if you have any questions or if you need further assistance.

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Tags
.NET Core DataSource SQL General Discussions Report Designer (standalone) Report Viewer - Blazor
Asked by
Akhil
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or