Supported Databases
- 2 minutes to read
DevExpress Reports support the following SQL database systems:
| Relational Database System | Supported Version | .NET Framework Data Provider | .NET Data Provider |
|---|---|---|---|
| Amazon Redshift | n/a | Npgsql.dll | Npgsql |
| Firebird | 1.5, 2.5.7, 3.0.2, 5.0.1 | 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 Access[1] | Access 2000 or higher Access 2007 or higher |
System.Data.dll | System.Data.OleDb |
| Microsoft SQL Server | SQL Server 2005 (with Express) SQL Server 2008 (with R2 & Express) SQL Server 2012, 2014, 2016, 2017, 2019, 2022, 2025 (with Express & LocalDB) SQL Azure™ Database Azure SQL Database |
Microsoft.Data.SqlClient.dll System.Data.dll (Included in .NET Framework) |
Microsoft.Data.SqlClient (recommended) or (deprecated) System.Data.SqlClient |
| 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, 10g, 11g, 12c, 18c, 21c, 23ai | Oracle.ManagedDataAccess.dll System.Data.OracleClient.dll Oracle.DataAccess.dll |
Oracle.ManagedDataAccess |
| Pervasive PSQL | 9.x or higher | Pervasive.Data.SqlClient.dll | |
| PostgreSQL | 7 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 |
Custom Connection Strings
Refer to the following help topic for the connection string examples: Custom Connection String.
-
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. For more information, review the following article: Connect to data in an Access database.
-
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.