in development server its working fine but after migrate to production.
i using db mysql
impossible connector .net to mysql got problem because data access working fine.
here is the error
An error has occurred while processing Report 'Report2': 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. ------------- InnerException ------------- Unable to find the requested .Net Framework Data Provider. It may not be installed.
connection string also same with data access connection string.
my code
public
class
CustomReportResolver : IReportResolver
{
protected
TokenBasedView tokenBased {
get
;
set
; }
public
Telerik.Reporting.ReportSource Resolve(
string
reportCode)
{
Telerik.Reporting.Report report =
new
Report2();
Telerik.Reporting.InstanceReportSource irs =
new
Telerik.Reporting.InstanceReportSource();
irs.ReportDocument = report;
return
irs;
}
}
i hope somebody can help me out.
thank you so much
10 Answers, 1 is accepted
here is class for my report that auto generated
partial
class
UsernameReport
{
#region Component Designer generated code
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private
void
InitializeComponent()
{
.......................
this
.sqlDataSource1.ConnectionString =
"server=192.188.x.x;database=xcloud;uid=xcloudDB;pwd=xcloud"
;
this
.sqlDataSource1.Name =
"sqlDataSource1"
;
this
.sqlDataSource1.ProviderName =
"MySql.Data.MySqlClient"
;
this
.sqlDataSource1.SelectCommand =
"select username from users"
;
...........
}
#endregion
private
Telerik.Reporting.DetailSection detailSection1;
private
Telerik.Reporting.Table table1;
private
Telerik.Reporting.TextBox textBox2;
private
Telerik.Reporting.TextBox textBox1;
private
Telerik.Reporting.SqlDataSource sqlDataSource1;
private
Telerik.Reporting.TextBox textBox3;
private
Telerik.Reporting.PageHeaderSection pageHeaderSection1;
private
Telerik.Reporting.TextBox textBox4;
private
Telerik.Reporting.PageFooterSection pageFooterSection1;
}
The error bubbled in the viewer comes from the attempt to use the selected data provider (installed on the machine) and the associated ADO.NET classes. Please check the Data provider is missing in the SqlDataSource wizard KB article, and verify the data provider is installed and registered properly on the machie, and that the application target platform is considered with the version of the installed .NET connector (x86 or x64 version).
I hope the provided information is helpful.
Regards,
Stef
Telerik
See What's Next in App Development. Register for TelerikNEXT.
Hi Every one,
I Developed Application and I used Telerik Reporting for Report so after completing Application If I am running that Application in My PC it's running properly but as soon as I am Migrating the Application to another machine and after running that Application as soon as I clicked on Reporting Report is not Generating and below Error I am getting.
Unable to find requested .net framework data provider. It may not be Installed.
Thanks
Zakaria
Please reply to Question I am waiting
Thanks
Zakaria
i think you just follow what @Stef said.
My problem solve after i install .net connector for mysql.
if still cannot, try to install same version into your local and add reference (set isLocal is true).
Not test yet.
have u install this?
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
if not, u need to install first. sometimes add reference is not enough, maybe got dependency of dll. if i not mistaken.
good luck bro
Ok Thanks
I am using SQLite Expert Professional 3 as a Database?
so which version I have to installed of sqlite library?