Unable to find the requested .Net Framework Data Provider

[faris]

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

[faris]

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;

 

 

    }


 

 

[Stef]

Hello Faris,

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

 

 

[Zak]

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

 

[Zak]

Please reply to Question I am waiting

 

Thanks 

Zakaria

[faris]

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.

 

[Zak]

I am using SQLite not SQL?

[faris]

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

[Zak]

I am studying the above given but I want to ask one thing that It is running properly on My Machine but not in another machine.

[faris]

because ur machine has been installed sql lite library. 

[Zak]

Ok Thanks 

I am using SQLite Expert Professional 3 as a Database?

so which version I have to installed of sqlite library?