Copyright: This is an original post by the blogger and may not be reproduced without the blogger's permission. https://blog.csdn.net/huyuyang6688/article/details/9036745
ODBC (Open Database Connectivity)
From the literal meaning can be seen, ODBC is the equivalent of an intermediate protocol, it can connect to all kinds of databases, even including EXCEL and text. It provides a unified usage to the program, the program if using ODBC to operate the actual database, regardless of the back-end database is DB2 or SQL Server, or upgraded, the program can almost always respond to the changes with no change.
Here's a rough description of how to establish an ODBC data source connection.
First, you have to find the ODBC data source driver, if your system is WinXP or Win7 32-bit, Control Panel - Administrative Tools - Data Source (if your system is Win7 64-bit, C:Windowssyswow64, find odbcad32.exe, open is, many friends may have encountered this situation, in Win7 64-bit control panel or system32 in the odbc32, can only add SQL Server), open the interface (the following figure).