# Data Provider is Missing in the SqlDataSource Wizard

## Environment

<table>
	<tr>
		<td>Product</td>
		<td>Progress® Telerik® Reporting</td>
	</tr>
	<tr>
		<td>Report Item</td>
		<td>SqlDataSource component</td>
	</tr>
</table>

## Description

The [SqlDataSource component](https://www.telerik.com/products/reporting/documentation/designing-reports/connecting-to-data/data-source-components/sqldatasource-component/overview) would list and work with any [ADO.NET provider](https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview) that is correctly registered on the device.

The list with ADO.NET providers is taken as described in [Obtaining the DbProviderFactory](https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/obtaining-a-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.

## See Also

* [How to register SqlDataSource data providers without driver installation](https://www.telerik.com/products/reporting/documentation/knowledge-base/how-to-register-sqldatasource-data-providers-without-driver-installation)
