Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Detailed Guide to DevExpress Reporting > Bind Reports to Data > SQL Database > Supported Databases
All docs
V24.2
Reporting
Product Information
What's New
.NET Support
Get Started with DevExpress Reporting
Create Different Report Types (Walkthroughs)
Detailed Guide to DevExpress Reporting
Introduction to Banded Reports
Bind Reports to Data
SQL Database
Supported Databases
Bind a Report to a Database
Bind a Report to a Stored Procedure
Bind a Report to a Stored Procedure (Runtime Sample)
Bind a Report to a Data Source Schema
Bind a Report to an MDB Database (Runtime Sample)
Bind a Report to a Microsoft SQL Server Database at Runtime
Register a Custom Schema Provider for a Synonym Database
Use Query Parameters
Change SQL Data Source Connection Settings at Runtime
XML File
Entity Framework
Business Object
Excel File
JSON Data
MongoDB Instance
XPO
Data Federation
Standard .NET Data Providers
Bind a Report to Multiple Data Sources
Bind a Report to Multiple Data Tables
Manage Data Sources at Runtime
Use Report Controls
Use Report Parameters
Shape Report Data
Use Custom Fonts
Arrange Dynamic Report Contents
Customize Appearance
Add Navigation
Provide Interactivity
Add Extra Information
Merge Reports
Use Expressions
Store and Distribute Reports
Globalize and Localize Reports
Reporting API
Memory Usage in Reporting - Best Practices
Localize Reporting Applications
Security Considerations
AI-powered Extensions
Visual Studio Report Designer
VS Code Report Designer
Reporting for Desktop
Reporting for .NET MAUI
Reporting for Web
Cloud Integration
.NET Aspire Integration
Cross-Platform .NET App UI
Backend Web API Service / REST API for Reporting
WCF Report Service
End-User Documentation
Redistribution and Deployment
API Reference
ASP.NET Core API Reference
Blazor API Reference
Client API Reference
Client API Reference (Web Forms & MVC)
Download CHM

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

IBM.Data.DB2.Core

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 (with Express & LocalDB)

SQL Azure™ Database

Azure SQL Database

System.Data.SqlClient.dll

System.Data.dll (Included in .NET Framework)

Microsoft.Data.SqlClient or System.Data.SqlClient

If the Microsoft.Data.SqlClient is not found, the System.Data.SqlClient provider is used.

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, 8, 9, 10, 11, 12, 15, 16, 17

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

3.x

System.Data.SQLite.dll 1.*

Microsoft.Data.SQLite 8.*

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.

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. For more information, review the following article: Connect to data in an Access database.