Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Collapse]Common Features
  [Expand]Data Binding Common Concepts
  [Collapse]Data Source Wizard
   [Collapse]Pages
    [Expand]Start Pages
    [Collapse]Connect to a Database
      Select a Data Connection
      Specify a Connection String
      Save the Connection String
      Create a Query or Select a Stored Procedure
      Configure Query Parameters
    [Expand]Connect to an Entity Framework Data Source
    [Expand]Connect to an Object Data Source
    [Expand]Connect to an Excel Data Source
   [Expand]Customization API
  [Expand]Expressions
  [Expand]Behaviors
  [Expand]Application Appearance
  [Expand]Filtering UI Context
  [Expand]High DPI Support
  [Expand]Scaffolding Wizard
  [Expand]Formatting Values
   HTML Text Formatting
  [Expand]Menus
  [Expand]Tooltip Management
  [Expand]Saving and Restoring Layouts
   Clipboard - Copy Data and Formatting
   Version Compatibility: Default Property Values
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Specify a Connection String

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

Provider

Database Provider Assembly

Download link

Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016
2005 Express Edition, 2008 R2 Express, 2012 Express, 2014 Express, 2016 Express
Azure SQL Database
.NET Framework Data Provider for SQL Server System.Data.dll Included in .NET Framework
Microsoft Access 2000 or higher Microsoft Jet OLE DB Provider
Microsoft Access Database Engine (ACE)
System.Data.dll Microsoft Access 2000-2003 - Microsoft Jet 4.0 Database Engine
Microsoft Access 2007 and later - Access Database Engine
Microsoft SQL Server CE 3.5, 4.0 .NET Framework Data Provider for SQL Server Compact System.Data.SqlServerCe.dll Included in .NET Framework
Oracle Database 9i or higher Oracle Data Provider for .NET/
.NET Framework Data Provider for Oracle
Oracle.DataAccess.dll, Oracle.ManagedDataAccess.dll
System.Data.OracleClient.dll
Download link/
Included in .NET Framework
Amazon Redshift n/a .NET data provider for PostgreSQL Npgsql.dll Download link
Google BigQuery n/a DevExpress.DataAccess.BigQuery ADO.NET provider DevExpress.DataAccess.BigQuery.dll Download link
Teradata 13.0 or higher .NET Data Provider for Teradata Teradata.Client.Provider.dll Download link
SAP Sybase Advantage Advantage Database Server 9.1 or higher Advantage .NET Data Provider Advantage.Data.Provider.dll Download link
SAP Sybase ASE Sybase Adaptive Server 12.0 or higher SAP Sybase ASE Database Client Sybase.Data.AseClient.dll Download link
SAP SQL Anywhere 11 or higher SAP SQL Anywhere Database Client iAnywhere.Data.SQLAnywhere.dll Download link
IBM DB2 9.5 or higher ADO.Net client from IBM IBM.Data.DB2.dll Download link
Firebird 1.5 or higher, Dialect 3 Firebird ADO.NET Data Provider FirebirdSql.Data.Firebird.dll
FirebirdSql.Data.FirebirdClient.dll
Download link
MySQL 4.1 or higher ADO.NET driver for MySQL MySql.Data.dll Download link
Pervasive PSQL 9.x or higher PSQL ADO.NET Data Provider Pervasive.Data.SqlClient.dll Download link
PostgreSQL 7.x or higher .NET data provider for PostgreSQL Npgsql.dll Download link
VistaDB 4, 5 VistaDB ADO.NET Provider VistaDB.5.NET40.dll Download link
SQLite 3.x ADO.NET provider for SQLite System.Data.SQLite.dll Download link
XML file n/a n/a 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.

How would you rate this topic?​​​​​​​