What is the ODBC data source in the Win8 system?

  
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.
Below we begin to introduce ODBC data sources. In the "Control Panel System and Security Management Tool", 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 method for configuring, adding, and deleting 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:
▲ 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.
▲System DSN: The ODBC system data source stores information about how to connect to a specified data provider. The system data source is visible to all users on the current machine.
▲ 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.
▲ Driver: The ODBC driver allows programs that support ODBC to get information from ODBC data sources. If you are installing a new driver, use its installer.
▲ 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.
▲ connection pool: The connection pool allows the application to reopen the connection handle, which saves the round trip process to the server.

Copyright © Windows knowledge All Rights Reserved