Demerits of ODBC
What demerits of ODBC does OLE DB overcome?
Expert
By breaking the characteristics and the functions of a DBMS into COM objects, OLE DB characteristic overcomes major demerits of ODBC. With ODBC, a vendor must make an ODBC driver for almost all DBMS characteristics and functions in order to participate in ODBC at all. This is a large task which requires a substantial initial investment. With OLE DB, but, a DBMS vendor can implement portions of their product.
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Define the CYCLE/NO CYCLE into a Sequence.
What are to objectives of OLE DB?
Illustrates the various extensions for stored procedures?
Explain the usage of the repository connectivity?
Explain the types of jobs we have within the Data stage?
Explain the following term: a) ROLAP b) MOLAP
Give a brief introduction of the term Virtual Data Warehousing?
Illustrates the TDS protocol in Sybase?
Justify whether all the Business Objects users build the data providers?
18,76,764
1934056 Asked
3,689
Active Tutors
1455047
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!