Friends who have researched the development of computers will definitely know ODBC. It is an old-fashioned thing. It has grown to 3.8 on Win8. Although Microsoft has not made a big update to ODBC, it is because ODBC is a mature and old specification, so its role is not so prominent, but if you are a database developer, you must know ODBC data. How important is the source. Let's take a look at the importance of ODBC.
ODBC Data Source Meaning: ODBC (Open Database Connectivity) is an application interface (API). This interface provides the ability to write applications independent of any data management system. OCBC provides a set of application interfaces to different database vendors for special database management systems (DBMS) through ODBC drivers. The user's application uses this set of APIs to schedule the ODBC driver. The driver then contacts the DBMS through the SQL statement.
How to open ODBC data source: In the "Control Panel\\System and Security\\Administrative Tools", you can see the ODBC data source icon. Double-click to open the ODBC Data Source Manager, as shown below:
ODBC Data Source Manager provides the most succinct way to configure, add, and delete various data source names. It allows users to easily configure the data source, and the user can delete the original DSN (data source name) or modify the previously configured data source.
The specific functions of the ODBC Data Source Manager are as follows:
1. User DSN: The ODBC user data source stores information about how to connect to the specified data provider. The user data source is only visible to the current user and can only be applied to the unit.
2, system DSN: ODBC system data source stores information on how to connect with the specified data provider. The system data source is visible to all users on the current machine.
3, file DSN: ODBC file data source allows users to connect to the data provider. The file DSN can be shared by users who have the same driver installed.
4, the driver: ODBC driver allows those programs that support ODBC to obtain information through ODBC data sources. If you are installing a new driver, use its installer.
5, tracking: ODBC tracking allows to create a log to call the ODBC driver for the technical staff to view; can also assist in debugging the application. Visual Studio tracks the ODBC trace that starts Microsoft Visual Studio.
6, connection pool: The connection pool allows the application to reopen the connection handle, this operation will save the round-trip process to the server.
Read the above content, I believe you will have a certain understanding of the ODBC data source, in fact, in the process of practice you will find that ODBC works like Windows, it uses the driver included in the DLL to complete the task. Because of speed issues, ODBC will never have much impact in the database world. But with Microsoft's market influence, ODBC is undoubtedly successful, and its outstanding contributions to every database development team should be remembered.