Ms Sql connection error

Mohamed Gahlan

when create report with sql data source and pass it to web report,it give me this error "Can't find object MsSqlDataConnection".

ipong

code please.... .net core and .net framework use same syntax

string connection = @"....";
using (SqlConnection cnn = new SqlConnection(connection))
{
    cnn.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM Data", cnn))
    {
        using (SqlDataReader dr = cmd.ExecuteReader())
        {
            while (dr.Read())
            {
               ...
            }
        }
    }
}

Mohamed Gahlan

I work with entity framework, and this error also happen if connect to sql directly from report designer and pass report file to web report while preview in designer work fine.

Mohamed Gahlan

code:

var Model = new WebReport();
Model.Report.Load("Reports/SQLReport.frx");
return View(Model);

report file in attachment

ipong

are you using mssql connection embedded in frx file? delete it!

ipong

are you using mssql connection embedded in frx file? delete it!

remember, report designer uses .net framework, and your web app uses .net standard (core) library

Mohamed Gahlan

do you mean Delete all Dictionary childs nodes from frx file or just delete MsSqlDataConnection node and let it's childs?

ipong

just mssql data connection.