What is ODBC.net data provider and how do I use it?

DETAILS
The ODBC.NET Data Provider is a native component to the .NET Framework version 1.1. This component provides access to native ODBC drivers in the same way that the OLE DB .NET Data Provider provides access to native OLE DB providers.

The ODBC.NET Data Provider is intended to work with all compliant ODBC drivers but only the following drivers have been tested with the ODBC.NET Data Provider:

  • Microsoft SQL ODBC Driver
  • Microsoft ODBC Driver for Oracle
  • Microsoft Jet ODBC Driver

Unlike the ODBC .NET data provider addon for .NET Framework 1.0, the namespace for this version changed from Microsoft.Data.Odbc to System.Data.Odbc.

To use ODBC .NET data provider with your ASP.net application, you will need to import the following name space

<%@ import Namespace="System.Data.Odbc" %>

Note that we are not recommending the use of ODBC. We recommend that customers use OLE or other .NET native data providers whenever possible.  OLE and other .NET native providers provide better performance.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

After I configure the custom error setting in the control panel, I still get the generic error page?

DETAILS Custom error setting is a web server setting which affects all file types (.htm, .gif,...

How do I connect my ASP.net application to MySQL database?

DETAILSIn general, 2 different methods can be used to connect an ASP.net application to MySQL...

How do I get my ASP.net application to display non-English language?

DETAILSASP.net allows the developer to encode the page using character sets other than...

How do I get my ASP.net application to display non-English language?

DETAILSASP.net allows the developer to encode the page using character sets other than...

How do I setup custom error for my ASP.net application?

DETAILS ASP.net has its own built-in error handling.  To set up custom error handling for...