What is Open Database Connectivity (ODBC)?

What does ODBC stand for?

Open Database Connectivity (ODBC) is an Interface preferred for gaining Access to facts and communicating with Database sySTEMs, regardless of the running machine (OS), Database gadget (DS) or Programming Language. This is done by the usage of ODBC Drivers that Function a Bridge between applications and database structures.

What Does Open Database Connectivity Mean?

In 1992, a group of producers added the ODBC Model as a communications solution for the massive number of OSs, DSs and applications written in distinctive Programming languages. For example, an utility written in C to access an Oracle Database in Unix needed to be rewritten if the utility cHanged to Windows, or if the database Platform was moved to Sybase. These manufacturers diagnosed the want for an interMediate translation mechanism and created a hard and fast of Protocols and Application Programming Interfaces (APIs), which become the first ODBC version.

The ODBC version includes the subsequent 3 most important additives:

• Client (commonly a programming application)
• Database Server
• ODBC Driver

The driving force’s Characteristic, which could be very much like a human translator, is to bridge the space among Events that might not otherwise apprehend every different.