"An error occurred while invoking data retrieval method.
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'System.Data.SqlClient, Version=4.6.1.1, Culture=neutral, PublicKeyToken=' or one of its dependencies. The system cannot find the file specified.."
1 Answer, 1 is accepted
Hi Oumaima,
Just a heads up, this is a duplicate to support ticket 1473722. However, to help anyone in the community experiencing the same error I will post the resolution here as well.
From the error, the report uses an ObjectDataSource that references the System.Data.SqlClient assembly. This assembly needs to be in the folder of the report designer so that the referring assembly can find it when executing the ObjectDataSource logic.
If other external assemblies are used by the ObjectDataSource assembly, they also need to be added in the designer folder. More information is available in the Extending Report Designer article.
For reference, the System.Data.SqlClient is an assembly that is distributed with a NuGet package. Ensure the exact version of the assembly from the package is used and copy it to the designer folder. This is also required for the other external dependencies of the ObjectDataSource assembly.
Lastly, at this time, the Standalone designer can resolve only assemblies built with the .NET Framework or .NET Standard 2.0. The designer is a .NET Framework Windows Forms application and cannot resolve .NET Core and .NET Standard 2.1+ assemblies. See the .NET Standard Support article for more details.
Please let me know if you need any additional information. Thank you for using the Reporting Forums.
Regards,
Eric R | Senior Technical Support Engineer
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.