What are the important functions of the Win8 system ODBC data source?

Friends who have researched the development of the computer will definitely know ODBC, it is an old thing, and the version on the Win8 system has been 3.8. 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:

The 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 you to create a log that calls the ODBC driver for the technician to view; it can also assist in debugging the application. Visual Studio tracks the ODBC trace that starts Microsoft Visual Studio.

6, connection pool: connection pool allows the application to reopen the connection handle, this operation will save the round-trip process to the server.

After reading 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. Completing the task, because of speed issues, ODBC will never have much impact in the database field. But with Microsoft's market influence, ODBC is undoubtedly successful, and its outstanding contributions to every database development team should be remembered.