What is an open database connection?

Open Database Connectivity (ODBC) is an interface between computer applications and databases. This interface provides a buffer layer between the database and the software used to access it. This means that any software can connect to any database regardless of the platform or method if both systems use ODBC. Basically, these two programs speak in their own languages ​​and translate information on open database connection. In 1995, Microsoft® released version 3 of the system that agreed that it was accepted as the basic standard for the structured language of queries (SQL). Within the SQL standard, the interface is widely used for various database purposes.

Before receiving an open database, database programs needed coded methods to interview diffement database styles. Programmers believed that these systems would need access to three different types of databases; Three different different ones were then programmed into the systemcommands for each function. The databases had the same redundancy; Each program demanded that the information be sent in a particular estate. If any of these programs were turned off in the syntax or met an unknown system, no communication was possible.

It all changed with the development and implementation of an open database connection. This basically works as a translator. Databases and applications programmers write methods that use the syntax used by ODBC. If the application requires information, sends a question and ODBC converts its syntax to the methods used in the database. The database sends the answer back and ODBC converts it back to the required application syntax.

This process works through the installed set of drivers. Each database has an associated specific driver of the open database connection. This driver performs a real translation between the database and the outside world. If changes in a specificIcacing causes the driver to be outdated, only the driver must change; The rest of the database may remain unchanged. This allows you to update the interface without many other encoding work.

Applications are basically built -in operator Open Database Connectivity. These drivers are part of the application programming. They can be updated because the program receives patches but are separate from the standard ODBC system.

Real communication occurs between these sets of drivers. The program drivers translate information before it is actually sent. The database drivers will receive a request in their own language, get information and send it, still in Syntax ODBC. The program drivers take back and translate them back into the program language. This two -layer system creates an interface that is almost reliable because real systems designers create their own interface.