Skip to main content
All docs
V25.2
  • 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.

    Footnotes
    1. 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.

    2. 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.