An ODBC (Open database connection) is an application's interface (API). This interface provides the ability to write applications independent of any data management system. OCBC provides a set of application interfaces for different database vendors to special database management systems (DBMS) through an ODBC driver. The user's application uses this set of APIs to schedule an ODBC driver. The driver then contacts the DBMS with the SQL statement.
Let's begin by introducing an ODBC data source. The ODBC Data source icon is visible in the Control Panel system and security management tools.
Double-hit open ODBC data Source Manager, as shown in the following illustration:
The ODBC Data Source Manager provides the most concise way to configure, add, and remove various data source names. It allows users to easily complete the configuration of the data source, and users can delete the original DSN (data source name) or modify the previously configured data source. The specific features of the ODBC Data Source Manager are as follows:
▲ User DSN:ODBC The user data source stores information about how to connect to the specified data provider. User data sources are visible only to the current user and can only be applied on this computer.
▲ System DSN:ODBC The system data source stores information about how to connect to the 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 data providers. File DSNs can be shared by users who have the same driver installed.
▲ drivers: ODBC drivers allow ODBC-enabled programs to get information from ODBC data sources. If you are installing a new driver, use its setup program.
▲ Tracing: ODBC tracing allows you to create logs that invoke ODBC drivers for the technical staff to view or to assist in debugging applications. Visual Studio tracks the ODBC trace that starts Microsoft Visual Studio.
▲ Connection pooling: Connection pooling allows the application to reopen the connection handle, which stores the roundtrip process to the server.