Supported Data Providers
- 2 minutes to read
The SqlDataSource component supports the following data providers:
| Relational Database System | Supported Versions | .NET Framework Data Provider | .NET Data Provider |
|---|---|---|---|
| Amazon Redshift | n/a | Npgsql.dll | Npgsql |
| Firebird | 1.5 or higher, Dialect 3 TODO | FirebirdSql.Data.FirebirdClient.dll FirebirdSql.Data.Firebird.dll |
FirebirdSql.Data.FirebirdClient |
| Google BigQuery | n/a | ODBC driver for BigQuery | ODBC driver for BigQuery |
| IBM DB2 | 9.5 or higher | IBM.Data.DB2.dll | Net.IBM.Data.Db2 |
| Microsoft SQL Server | 2005 or higher 2005 Express or higher Azure SQL Database |
Microsoft.Data.SqlClient.dll System.Data.dll (Included in .NET Framework) |
Microsoft.Data.SqlClient |
| Microsoft Access[1] | Access 2000 or higher Access 2007 or higher |
System.Data.dll (Included in .NET Framework) | System.Data.OleDb |
| Microsoft SQL Server CE | 3.5, 4.0 | System.Data.SqlServerCe.dll (Included in .NET Framework) | |
| MySQL | 4.1 or higher 5.5, 5.6, 5.7, 8.0, 8.3, 9.1 (for the MySqlConnector provider) |
MySqlConnector MySql.Data |
MySqlConnector MySql.Data |
| Oracle Database | 9i or higher | Oracle.ManagedDataAccess.dll System.Data.OracleClient.dll Oracle.DataAccess.dll |
Oracle.ManagedDataAccess.Core |
| Pervasive PSQL | 9.x or higher | Pervasive.Data.SqlClient.dll | |
| PostgreSQL | 7.x or higher | Npgsql.dll | Npgsql |
| SAP HANA | 2.0 or higher | SAP HANA Client 2.0 | SAP HANA Client 2.0 Sap.Data.Hana.Core.v2.1.dll |
| SAP Sybase Advantage | Advantage Database Server 9.1 or higher | Advantage.Data.Provider.dll | |
| SAP Sybase ASE | Sybase Adaptive Server 12.0 or higher | Sybase.AdoNet4.AseClient.dll | |
| SAP SQL Anywhere | 11 or higher | Sap.Data.SQLAnywhere.dll | |
| SQLite[2] | 3.x | System.Data.SQLite.dll 2.* | Microsoft.Data.SQLite 8.* and SQLitePCLRaw.bundle_e_sqlite3 |
| Teradata | 13.0 or higher | Teradata.Client.Provider.dll | Teradata.Client.Provider |
| VistaDB | 4, 5, 6 | VistaDB.4.dll 4.* VistaDB.5.NET40.dll 5.* VistaDB.6.dll |
|
| XML file | n/a | Built-in support | Built-in support |
For more information, review the following article: Connect to data in an Access database.
-
If your project in Visual Studio 2022 has to connect to Microsoft Access databases, note that Visual Studio 2022 is a 64-bit process, and Microsoft OLE DB Provider for Jet and the Jet ODBC driver are only available in 32-bit versions. It is recommended that you use the 64-bit Microsoft Access Database Engine (Access Connectivity Engine, ACE), or use an earlier version of Visual Studio (VS 2019) that supports 32-bit database providers.
-
In .NET projects, the Microsoft.Data.SQLite library does not support the Any CPU platform target because SQLite requires architecture-specific native binaries. You need to change your project’s platform target to a specific architecture.