What is odbc in mysql

In mysql, the Chinese meaning of odbc is "open database connection". It is an open standard application programming interface (API) used to access the database, allowing connections to SQL database servers. odbc was developed according to the specifications of the SQL Access Group, which defines a set of function calls, error codes, and data types that can be used to develop database-independent applications.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

What is ODBC?

In mysql, the full name of odbc is "Open Database Connectivity", which means "open database connection" in Chinese.

ODBC is an open standard application programming interface for accessing databases (API). In 1992, Microsoft collaborated with Simba to create the world's first ODBC driver; SIMBA.DLL and standards-based data access were born. By using ODBC statements in your program, you can access files in several different public databases. In addition to ODBC software, each database to be accessed requires a separate module or driver.

ODBC provides a way for client programs to access numerous databases or data sources. ODBC is a standardized API that allows connections to SQL database servers. It was developed according to the specifications of the SQL Access Group, which defines a set of function calls, error codes, and data types that can be used to develop database-independent applications. Typically, ODBC is used when database independence is required or when different data sources need to be accessed simultaneously.

ODBC Overview

ODBC has become the de facto standard for standards-based data access in relational and non-relational database management systems (DBMS). Simba worked closely with Microsoft to develop the ODBC standard back in the early 1990s. The ODBC standard enables maximum interoperability, allowing application developers to write a single application to access data sources from different vendors. ODBC is based on the Call Level Interface (CLI) specification of the Open Group and ISO/IEC's Database API and uses Structured Query Language (SQL) as its database access language.

ODBC architecture

The data connection architecture based on ODBC is as follows:

Applications that support ODBC Program

This is any ODBC compliant application such as Microsoft Excel, Tableau, Crystal Reports, Microsoft Power BI, or similar applications (spreadsheets, word processors, data access and retrieval tools, etc. ). ODBC-enabled applications perform processing by passing SQL statements to the ODBC driver manager and receiving results from it.

ODBC Driver Manager

The ODBC Driver Manager loads and unloads ODBC drivers on behalf of applications. Windows platforms come with a default driver manager, while non-Windows platforms have the option of using open source ODBC driver managers such as unixODBC and iODBC. The ODBC Driver Manager handles ODBC function calls or passes them to the ODBC driver and resolves ODBC version conflicts.

ODBC Driver

The ODBC driver handles ODBC function calls, submits SQL requests to a specific data source and returns the results to the application. The ODBC driver can also modify an application's request so that the request conforms to the syntax supported by the associated database. Simba Technologies provides a framework for easily building ODBC drivers, as well as ODBC drivers for many data sources such as Salesforce, MongoDB, Spark, and more. The Simba SDK is available in C, Java, and C# and supports building drivers for Windows, OSX, and many *Nix distributions.

Data source

The data source is just the source of data. It can be a file, a specific database on a DBMS, or even a live data feed. The data may be on the same computer as the program, or it may be on another computer somewhere on the network.

[Related recommendations: mysql video tutorial]

The above is the detailed content of What is odbc in mysql. For more information, please follow other related articles on the PHP Chinese website!