locked
What's the difference between database driver and data provider? RRS feed

  • Question

  • What's the difference between database driver and data provider?
    Tuesday, January 18, 2011 12:19 PM

Answers

  • Hi,

    Driver is a program installed on a workstation or a server; it allows programs to interact with a Database Management System (DBMS). Such as, JDBC driver provides database connectivity through the standard JDBC application program interface (APIs) available in J2EE.

    A data provider is a set of libraries that is used to communicate with data source. Such as, SQL data provider for SQL, Oracle data provider for Oracle, OLE DB data provider for access, excel and MySQL.

    A data provider serves as a bridge between an application and a data source. A data provider is used to retrieve data from a data source and to reconcile changes to that data back to the data source.

    For more information, please see:
    http://msdn.microsoft.com/en-us/library/a6cd7c08(v=VS.100).aspx

    Thanks,
    Ai-Hua Qiu


    Ai-hua Qiu[MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Proposed as answer by Ai-hua Qiu Friday, January 21, 2011 3:22 AM
    • Marked as answer by Ai-hua Qiu Wednesday, January 26, 2011 8:09 AM
    Friday, January 21, 2011 3:21 AM