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

Designing the database schema , The domain that you will model in this assi...

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

Aggregation, Aggregation : One limitation of the E-R diagram is that they d...

Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent

Define various ways in which select statement, Define various ways in which...

Define various ways in which SELECT statement can be used for record selection Technology?  SELECT gives you control over a number of aspects for record retrieval: 1) Which

What is stored procedure, What is Stored Procedure? A stored procedure ...

What is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

Define the terms entity set and relationship set, Define the terms i) Entit...

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Explain the term- event, Event Occurrence of a process is called event...

Event Occurrence of a process is called event. In other words, the object can receive many input instructions. The changes which occur due to these instructions are known as e

What is oracle databse structure, What is Oracle databse structure? Or...

What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

Give the forms of triggers, Give the forms of triggers? The triggering ...

Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing

How to insert data in your table from another table, How to Insert data in ...

How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp

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