There is a paragraph in the Machine.config (c:/windows/microsoft.net/framework/v2.0.50727/config) file:
<system.data> <DbProviderFactories> <add name= "ODBC data Provider" invariant= "system. Data.odbc "description=". Net Framework Data Provider for Odbc "type=" System.Data.Odbc.OdbcFactory, System.Data, Version =2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 "/> <add name=" OLE DB Data Provider "invariant=" System.Data.OleDb "description=". Net Framework Data Provider for OLE DB "Type=" System.Data.OleDb.OleDbFactory, System.Data, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 "/> <add name=" OracleClient Data Provider "invariant=" System.Data.OracleClient "description=". Net Framework Data Provider for Oracle "type=" System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, version=2.0.0.0, Culture=neutral, publickeytoken=b77a5c561934e089 "/> <add name=" SqlClient Data Provider "invariant=" System.Data.SqlClient " Description= ". Net Framework Data Provider for SQL Server" Type= "SYstem. Data.SqlClient.SqlClientFactory, System.Data, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089 "/ > <add name= "Microsoft sql Server Compact Data Provider" invariant= "system.data.sqlserverce.3.5" descript Ion= ". NET Framework Data Provider for Microsoft sql Server Compact" type= "System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, version=3.5.0.0, Culture=neutral, publickeytoken=89845dcd8080cc91 "/></ Dbproviderfactories> </system.data>
If you--->providername= "System.Data.OleDb" for the Aceess database
If--->providername= "System.Data.OracleClient" or providername= "Oracle.DataAccess.Client" for the Oracle database
If you--->providername= "System.Data.SqlClient" for the SQL database
Other:
Providername= "System.Data.Odbc" is available for all database configurations.
If you--->providername= "System.Data.Odbc" for the MySQL database
C # providername drivers for accessing each database