windowsforms-118391-common-features-data-source-wizard-wizard-pages-start-pages-select-the-data-source-type.md
This wizard page allows you to select the required data connection type.
You can select a provider and click the “star” icon to pin frequently used database providers as favorites. These favorite providers are displayed at the top of the list for quick access:
The search panel allows you to filter the connection type list:
Click Next to proceed to the next wizard page, depending on the selected data connection type.
The XPO Data Source is hidden from the list of data sources available in the Data Source Wizard.
To customize the list of displayed data connection types, use the DataSourceWizardSettings.AvailableDataSourceTypes property. Also, you can limit the SQL data providers displayed in the Select a Data Connection Type page with the SqlWizardSettings.AvailableDataProviders property.
The following table lists all supported data source providers you can select on the Select a Data Connection Type page:
|
Relational Database System
|
Supported Versions
|
.NET Framework Data Provider
|
.NET Data Provider
| | --- | --- | --- | --- | |
Microsoft SQL Server
|
2005 or higher
2005 Express or higher
Azure SQL Database
|
System.Data.dll (Included in .NET Framework)
|
| |
Microsoft Access
|
Access 2000 or higher
Access 2007 or higher
|
System.Data.dll (Included in .NET Framework)
|
| |
Microsoft SQL Server CE
|
3.5, 4.0
|
System.Data.SqlServerCe.dll (Included in .NET Framework)
|
| |
Oracle Database
|
9i or higher
|
System.Data.OracleClient.dll
Oracle.DataAccess.dll
|
Oracle.ManagedDataAccess.Core.dll
| |
Amazon Redshift
|
n/a
|
|
| |
Google BigQuery
|
Only legacy SQL functions and operations are supported
|
|
| |
Teradata
|
13.0 or higher
|
|
| |
SAP HANA
|
2.0 or higher
|
|
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
|
|
| |
SAP SQL Anywhere
|
11 or higher
|
|
| |
IBM DB2
|
9.5 or higher
|
|
| |
Firebird
|
1.5 or higher, Dialect 3
|
FirebirdSql.Data.FirebirdClient.dll
FirebirdSql.Data.Firebird.dll
|
FirebirdSql.Data.FirebirdClient.dll
| |
MySQL
|
4.1 or higher
|
|
| |
Pervasive PSQL
|
9.x or higher
|
|
| |
PostgreSQL
|
7.x or higher
|
|
| |
VistaDB
|
4, 5
|
|
| |
SQLite
|
3.x
|
|
Microsoft.Data.Sqlite.Core.dll
| |
XML file
|
n/a
|
Built-in support
|
Built-in support
|