ASP.NET 4 Unleashed

Connecting to Other Databases

If you need to connect to any database server other than Microsoft SQL Server, you need to modify the SqlDataSource control’s ProviderName property.

The .NET Framework includes the following providers:

• System.Data.OracleClient— Use the ADO.NET provider for Oracle when connecting to an Oracle database.

• System.Data.OleDb— Use the OLE DB provider when connecting to a data source that supports an OLE DB provider.

• System.Data.Odbc— Use the ODBC provider when connecting to a data source with an ODBC driver.

Note

You can configure additional providers that you can use with the SqlDataSource control by adding new entries to the <DbProviderFactories> section of the Machine.config file.

For performance reasons, you ...