Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    database providers

    Hi my friends,
    Am so confused with the concepts of providers and drivers in database.
    Can i know the difference between the following concepts like
    oledb providers,odbc providers,sql providers,ADO,ADO.NET, and their drivers.

    Can any one help me to clear these...............

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Maybe this will help.

    OleDB is a low-level api (applications Programming Interface) which allows applications a standardized interface to communicate with various databases. Although it's very powerful, OleDB can be quite complex to use. Each different database requires its own 'database provider.'

    ODBC is another, older API layer which sits between the application, and the database. In order to connect to multiple database types, each database type requires the installation of its own 'database driver'

    ADO is a set of Component Object Model (COM) objects, and it sits between the application and OleDB. ADO.Net is an ADO based, dotNet specific version of ADO. ADO may connect through existing ODBC drivers, by using the MSDASQL OleDB Provider, OR you may connect directly to the individual databases by using their OleDB providers.

    If you can locate a copy of Rob MacDonalds "Serious ADO:Universal Data Access with Visual Basic," there's a handy diagram outlining the various APIs, drivers, and providers.

    Here's simplified version from Microsoft.
    Attached Thumbnails Attached Thumbnails ADO Object Model.JPG  
    Last edited by loquin; 05-07-07 at 19:30.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts