What are the uses of odbc, Database Management System

Assignment Help:

What are the uses of ODBC? Under what circumstances we use this technology?

ODBC expose database capabilities within a standardized way to the application programmer by an application programming interface (API). In difference to Embedded SQL, ODBC permits a single executable to access various DBMSs without recompilation. Therefore, although Embedded SQL is DBMS- independent just at the source code level, applications using ODBC are DBMS- independent at the source code stages and at the level of the executable.

All direct interaction along with a exact DBMS happens by a DBMS-specific driver. A driver is a software program which translates the ODBC calls within DBMS-specific calls. Drivers are loaded dynamically on demand because the DBMSs the application is going to access are known just at run-time. Available drivers are registered along with a driver manager. The driver translates the SQL commands from the application within equivalent commands in which the DBMS understands. An application which interacts along with a data source by ODBC selects a data source, dynamically loads the corresponding driver, and establishes a connection along with the data source. ODBC achieves portability at the stages of the executable through introducing an extra level of indirection. Further, using ODBC, an application could access not only one DBMS but several various ones simultaneously.


Related Discussions:- What are the uses of odbc

Describe about use case and external case in dfd, Describe about Use Case a...

Describe about Use Case and external case in DFD The processes are transformed those into the Use Case and external case in DFD has same characteristics which of an actor in O

Define null values, Define null values. In some cases a certain entity ...

Define null values. In some cases a certain entity may not have an applicable value for an attribute or if we do not know the value of an attribute for a certain entity. In the

Database, real life situations where database management system are most su...

real life situations where database management system are most suitable

Mapping, external and internal mapping with examples

external and internal mapping with examples

Describe the benefits of OOD techniques, Describe the benefits of OOD techn...

Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

Data aggregation, Q.   Explain  data aggregatio n and discuss differen...

Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

What is meant by data-transfer rate, What is meant by data-transfer rate? ...

What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

Explain the function of object model, Explain the function of Object model ...

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object

What create when a primary key combined with a foreign key, What will be cr...

What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd