What Disadvantage Of Odbc Does Ole Db Overcome?

1.	What Disadvantage Of Odbc Does Ole Db Overcome?
Answer» By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a VENDOR must create an ODBC driver for almost all DBMS features and functions in order to participate in ODBC at all. This is a large task that REQUIRES a substantial initial investment. With OLE DB, however, a DBMS vendor can implement portions of their product. By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a vendor must create an ODBC driver for almost all DBMS features and functions in order to participate in ODBC at all. This is a large task that requires a substantial initial investment. With OLE DB, however, a DBMS vendor can implement portions of their product.

Answer»

By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a VENDOR must create an ODBC driver for almost all DBMS features and functions in order to participate in ODBC at all. This is a large task that REQUIRES a substantial initial investment. With OLE DB, however, a DBMS vendor can implement portions of their product.

By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a vendor must create an ODBC driver for almost all DBMS features and functions in order to participate in ODBC at all. This is a large task that requires a substantial initial investment. With OLE DB, however, a DBMS vendor can implement portions of their product.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?