Specify a Connection String

• Aug 03, 2020
• 2 minutes to read

On this page, define a custom connection string or select one of the supported data source types.

The following data source types are supported.

SQL Data Source	Supported Versions	Data Provider	.NET Standard Support
Microsoft SQL Server	2005, 2008, 2008R2, 2012, 2014, 2016 2005 Express Edition, 2008 R2 Express, 2012 Express, 2014 Express, 2016 Express Azure SQL Database	System.Data.dll (Included in .NET Framework) System.Data.SqlClient
Microsoft Access	2000 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
Amazon Redshift	n/a	Npgsql.dll
Google BigQuery	n/a	DevExpress.DataAccess.BigQuery.dll
Teradata	13.0 or higher	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
SAP SQL Anywhere	11 or higher	Sap.Data.SQLAnywhere
IBM DB2	9.5 or higher	IBM.Data.DB2.dll
Firebird	1.5 or higher, Dialect 3	FirebirdSql.Data.Firebird.dll FirebirdSql.Data.FirebirdClient.dll
MySQL	4.1 or higher	MySql.Data.dll
Pervasive PSQL	9.x or higher	Pervasive.Data.SqlClient.dll
PostgreSQL	7.x or higher	Npgsql.dll
VistaDB	4, 5	VistaDB.5.NET40.dll
SQLite	3.x	System.Data.SQLite.dll Microsoft.Data.SQLite
XML file	n/a	n/a

Depending on the data provider selected, it may be necessary to specify additional connection options (such as authentication type and database name) on this page.

Click Next to proceed to the next wizard page: Save the Connection String.