This is a migrated thread and some comments may be shown as answers.

Using Oracle.ManagedDataAccess in Telerik reporting

3 Answers 113 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Thomas Kjaereng
Top achievements
Rank 1
Thomas Kjaereng asked on 08 Mar 2017, 09:56 AM

We are currently using Oracle.ManagedDataAccess (https://www.nuget.org/packages/Oracle.ManagedDataAccess/) for our application to connect to oracle.

 

However, we have integrated Telerik Reporting in our WPF application, and we're using System.Data.OracleClient for that. 

 

Now though, we have run into a problem where some of our client computers does not have System.Data.OracleClient installed, and installing this is not an option. Because we have bundled Oracle.ManagedDataAccess with our application, we hope to use this provider for telerik as well. 

 

I changed the connection string manager to use Oracle.ManagedDataAccess.Client as a provider, however this causes an error message to be displayed in the report viewer, saying that the provider could not be found. 

 

So, the question; Is it possible to use Oracle.ManagedDataAccess for telerik reporting, and if so; how can I configure this to work correctly?

3 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 08 Mar 2017, 02:19 PM
Hello Thomas,

Please test setting the following:
  1. In the report set the SqlDataSource component's ProviderName property to the name of the .NET data provider you want to use;
  2. In the named connection string in the application's configuration file, under connectionStrings element, set the providerName attribute to the correct provider. The setting is required for the connection string specified by the report's SqlDataSource.ConnectionString property.

Let us know if the above suggestions help.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Thomas Kjaereng
Top achievements
Rank 1
answered on 10 Mar 2017, 07:53 AM

Unfortunately this does not help us, because we set the connection string and provider programatically at runtime. 

In code, I set the SqlDataSource connection string to the same string as we use in our application, and I set the provider name to "Oracle.ManagedDataAccess.Client"

The error message says Unable to find the requested .Net Framework Data Provider.  It may not be installed.

It is, in fact, not installed, but rather bundled with our application as a .dll (Oracle.ManagedDataAccess.dll). 

So; is it possible to use this client? 

0
Stef
Telerik team
answered on 10 Mar 2017, 10:30 AM
Hello Thomas,

Please check this forum post and test registering the data provider in the application's configuration file. The settings are in addition to setting the SqlDataSource component's ProviderName property and the connection string's providerName attribute.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Thomas Kjaereng
Top achievements
Rank 1
Answers by
Stef
Telerik team
Thomas Kjaereng
Top achievements
Rank 1
Share this question
or