SQL Database

• Dec 16, 2019
• 2 minutes to read

DevExpress reports support the following SQL database systems:

Relational Database System	Supported Versions	.NET Framework Data Provider	.NET Standard 2.0 Data Provider
Microsoft SQL Server	2005 or higher 2005 Express or higher Azure SQL Database	System.Data.SqlClient.dll System.Data.dll (Included in .NET Framework)	System.Data.SqlClient.dll
Microsoft Access	Access 2000 or higher Access 2007 or higher	System.Data.dll
Microsoft SQL Server CE	3.5, 4.0	System.Data.SqlServerCe.dll (Included in .NET Framework)
Oracle Database	9i or higher	Oracle.ManagedDataAccess.dll System.Data.OracleClient.dll Oracle.DataAccess.dll	Oracle.ManagedDataAccess.dll
Amazon Redshift	n/a	Npgsql.dll	Npgsql.dll
Google BigQuery	Only legacy SQL functions and operations are supported	DevExpress.DataAccess.BigQuery.dll	DevExpress.DataAccess.BigQuery.dll
Teradata	13.0 or higher	Teradata.Client.Provider.dll	Teradata.Client.Provider.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
IBM DB2	9.5 or higher	IBM.Data.DB2.dll	IBM.Data.DB2.Core.dll
Firebird	1.5 or higher, Dialect 3	FirebirdSql.Data.FirebirdClient.dll FirebirdSql.Data.Firebird.dll	FirebirdSql.Data.FirebirdClient.dll
MySQL	4.1 or higher	MySql.Data.dll	MySql.Data.dll
Pervasive PSQL	9.x or higher	Pervasive.Data.SqlClient.dll
PostgreSQL	7.x or higher	Npgsql.dll	Npgsql.dll
VistaDB	4, 5	VistaDB.5.NET40.dll
SQLite	3.x	System.Data.SQLite.dll Microsoft.Data.SQLite	System.Data.SQLite.dll Microsoft.Data.SQLite
XML file	n/a	Built-in support	Built-in support

Use the Report Wizard or the Data Source Wizard to bind a report to data at design time. See the following tutorials for details:

• Bind a Report to a Database
• Bind a Report to a Data Source Schema
• Bind a Report to a Stored Procedure

Use the SqlDataSource class to bind a report to an SQL database at runtime. See the following tutorials for code examples:

• Bind a Report to an MDB Database (Runtime Sample)
• Bind a Report to a Microsoft SQL Server Database (Runtime Sample)
• Register a Custom Schema Provider for a Synonym Database

Tip

See Bind a Report to Standard .NET Data Providers to learn how to bind your report to an OLE DB provider or an existing DataSet object.