Using Oracle.ManagedDataAccess in Telerik reporting

[Thomas Kjaereng]

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?

[Stef]

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

[Thomas Kjaereng]

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? 

[Stef]

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