The term ODBC may still be rarely heard for ordinary people. However, for system developers, the term ODBC is commonly used. Typically, developers use ODBC to connect several types of databases that support the use of ODBC.
The use of ODBC has many advantages, including helping developers create database applications, without having to understand the use of database management systems certain. Because, it is handled directly by ODBC. In addition, by using you can also access the application without having to install the appropriate database with the application.
For those of you who use Windows operating system, ODBC is installed automatically, you just enable it via Control Panel . Have you understood the notion of ODBC? Therefore, in this article will be explained about the definition of ODBC, its function and the main components contained in ODBC. Immediately to the first discussion, which is about the definition of ODBC below.
The definition of ODBC
In designing a database system, either based on client or server then to avoid dependence with certain programming languages, certain operating systems, certain database management systems then required Open Database Connectivity (ODBC). Then, what is the meaning of ODBC?
ODBC is a standard protocol that connects between machines database. Basically the "ModBC driver" is available only in the Windows operating system. Because, ODBC is still part of Windows Open System Architecture (WOSA). All you need to know is that in ODBC it has many APIs (Application Programming Interface), where API is used to run and connect an application through database management system you use
With ODBC, it can help application designer to access, view and process multiple apps at once. The ODBC driver supports several database types, such as Ms SQL Server, Ms FoxPro, Ms Access and Ms Oracle and so on.
Basically, ODBC (Open Database Connectivity) has the purpose of helping application developers to be free from use certain programming languages, certain database management systems so that they can still be accessed using the same source code. In addition, there are some functions you need to know by using ODBC. Below are ODBC functions, namely:
- ODBC functions in assisting users in processing data, being the interface in processing data between multiple databases
- ODBC serves as a standard protocol that connects multiple databases. However, the database provides drivers that support ODBC.
- ODBC can help you access databases, both local and non-local (client / server) using the DSN (Data Source Name) system.
ODBC Main Component
ODBC has several main components, among which are as follows:
1. ODBC API
In the ODBC API component, there are some function calls, error codes and SQL syntax to define data access in a Database Management System (DBMS) . In addition, the ODBC API also performs the following activities:
- Gives requests for interaction with data source [data source]
- Sends request SQL syntax to data source
- Detects process error
- Performing requests for transaction control operations
- Terminating connection to data source
2. ODBC Driver Manager
ODBC Driver Manager aims to set the ODBC database driver needed to access the application. The driver manager also performs the following functions:
- Mapping the data source name for a DLL-specific driver (Dynamic-link Library)
- Performing multiple call processes to initialize ODBC
- Giving entrance to ODBC function for each driver
- validation, such as parameters and sequence for calling ODBC
3. ODBC Database Driver
Database Driver is a driver capable of processing function calls on ODBC, requesting SQL to a specific data source, where the results of that process will return to the Application. In addition, the driver also needs to modify the application request so that the request matches the syntax and is supported by the appropriate DBMS.
A driver is also capable of performing tasks to respond to ODBC function calls via the ODBC API component:
- Establish a connection to data source
- Submit request to data source
- Return results to application component
- Declare and manipulate if needed
4. Data Source
Data source is a collection of databases to be accessed by drivers, where each data source should be identified during setup. In other words, data source is a specific example that is a combination of DBMS products with remote operating systems and networks needed to access data. You can set the source data in Control Panel contained in Windows
How the Components Interact Each Other
After knowing the main components of ODBC, then below will explain how each component interacts with each other. The following explanation.
Initially the application will be accessed by using API (Application Programming Interface). Then the ODBC API component requests data from / or to send data to the back-end or so-called DBMS Server (data source). However, the DBMS can not understand the ODBC client request to bypass the ODBC driver for a particular DBMS.
The ODBC driver is software that works on the front-end. The command will be translated by ODBC Driver into an understandable ODBC Server format. Then, ODBC Server sends the result to the ODBC driver, which will eventually be translated back into an answer to an understandable ODBC Client format.
That is the discussion of the definition of ODBC, the function of ODBC and the main components contained in ODBC. That way, you can use ODBC to access applications designed using multiple programming languages.