Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[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]Wizard 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
    Query Builder
   [Expand]Wizard 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 and Paste Operations. Data 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]ASP.NET Core 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]CodeRush Classic
[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

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.

Is this topic helpful?​​​​​​​