Data Provider is Missing in the SqlDataSource Wizard
Environment
| Product | Progress® Telerik® Reporting |
| Report Item | SqlDataSource component |
Description
The SqlDataSource component would list and work with any ADO.NET provider that is correctly registered on the device.
The list with ADO.NET providers is taken as described in Obtaining the DbProviderFactory article and lists all of the provider factories registered in the machine.config.
Solution
For instance, if MySQL provider is not registered correctly, but shows in Visual Studio, this means its installation has only registered it in Visual Studio and you can open devenv.exe.config to get the provider details and add it manually to the config file of the standalone designer(Telerik.ReportDesigner.exe.config).
If it is not listed in Visual Studio either, then most likely your installation of the MySQL ADO.NET provider did not complete successfully and you can try upgrading to a newer version, or repairing.